BusinessObjects Board

Count Formula

building reports webintelligence
#1

We have a table like this:
COUNTRY CITY SELL
USA NEWYORK 1000
USA WASHIN 200
CHINA Beijing 500
CHINA Shanghai 1000
CHINA Suzhou 700
CHINA ChangSha 200
UK LD 1000
We want to count city number according to sell number:
USA CHINA UK
<300 1 1 0
300-800 0 2 0

800 1 1 1
How to make this variant?

I set <300 variant like : SUM(IF([SELL]<300;1;0) but is error

fangzhou8002 (BOB member since 2008-10-17)

#2

Hello!

please take a look a this thread, it will possibly guide you into the solution: https://bobj-board.org/t/44371

Regards

radiohead :portugal: (BOB member since 2007-04-13)

#3

I have tried foreach ,but it’s also wrong.

The main question is I should sum CITY,but in report don’t show CITY field.

fangzhou8002 (BOB member since 2008-10-17)