Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you post your complete expression which you are trying.
Regards
Try count({<products={"=sum(sales)<sum(target)"}>}products)
hi
i am using this exp;
=count({<products={'=sum(sales)<target'}>}products)
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
sorry if i select products 'p1
That's very interesting. It's showing 1 as result here based on the example data you posted.
Hi Baru,
Can you elaborate your Query. As you said aggregation by region is giving count 0 . But this should give the count.
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