aggr in count

[#1]

Hi All,

I want to show count(products) based on 'sales < target'

exp : if(sales<target,count(products))

region	country	products	target	sales
a	1	p1	10	20
b	2	p2	20	9
c	3	p1	50	45
d	4	p4	60	61

Here for product 'p1', region 'c' sales is less than the target,but it aggregated with region 'a' .count it is showing 0, because target is aggr .

i want to show this in text box.

any help

[PrashantSangle]

Hi,

Can you post your complete expression which you are trying.

Regards

[Gysbert_Wassenaar]

Try count({<products={"=sum(sales)<sum(target)"}>}products)

[#4]

hi

i am using this exp;

=count({<products={'=sum(sales)<target'}>}products)

[#5]

Hi Gysbert,

thanks for the reply,

it value showing '2',but it should be 1,because for region'c' is only not reached the target.

any help

[#6]

sorry if i select products 'p1

[Gysbert_Wassenaar]

That's very interesting. It's showing 1 as result here based on the example data you posted.

[timanshu]

Hi Baru,

Can you elaborate your Query. As you said aggregation by region is giving count 0 . But  this should give the count.

[robert_mika]

Create an alternate state

Setting  - Document Properties-Alternate state—Add..

And then go to the textbox with the expression Gysbert has provided and choose from dropdown this State