Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning, I want to count how many stores reflect a positive or a negative volume growth.
My expression is as follows:
=Count({< vVolumeGrowth = {'<0'} >}distinct [Store Description])
It shows the total number of stores 2.88k not the amount with negative growth.
Thought?
Thanks
How is your variable vVolumeGrowth defined? Or, this is an input value from user?
Hi, it as below
(sum ({$<Year= {$(vMaxYear)}>} (Units))
/
sum ({$<Year={$(=Max(Year)-1)},Cal_YearMonth = {"<= $(=Max(Cal_YearMonth)-101)"}>} (Units)))-1
In set modifier, a field name is expected before the '=' sign. In your case, you are passing a possible numeric value which is not accepted.
Can you provide an example?