Count Growth by Store

[CerebosSA]

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

[tresesco]

How is your variable vVolumeGrowth defined? Or, this is an input value from user?

[CerebosSA]

Hi, it as below

(sum ({$<Year= {$(vMaxYear)}>} (Units))

/

sum ({$<Year={$(=Max(Year)-1)},Cal_YearMonth = {"<= $(=Max(Cal_YearMonth)-101)"}>} (Units)))-1

[tresesco]

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. 

[CerebosSA]

Can you provide an example?