How to count expression with minus value?

[#1]

Hi all,

I'm wondering how to count stores that i had with minus value, in this case my YTD Growth value, i use

Count(

{< vYTDamt = {'<0'} >} Distinct (Stores)

)

but i had that error in modifier expression, So anyone can help me? i attach an image for detail,

Thanks a lot,

Cheers,

[#2]

All,

Anybody know how to solve this issue?

[vinafidalgo]

I'm still trying when I have free time.

Can you upload the data sources?
I may need to reload the document for test purposes.

[#4 · Accepted solution]

Hi Ferdinand,

please see attached, correct total is 26 yes?

hope that helps

Joe

[vinafidalgo]

Ferdinand,

JosSimmons posted the correct solution.

Please check if it solve your problem.

[#6]

Works like a charm! cool! thanks a lot JoeSimmons

[#7]

Yes! its correct.. finally, thanks Vinicius

[#8]

Oh, btw.. what if i want to count the opposite value, positive value.. [YTD Growth] > 0 , i edit the script but its not that simple.. the total goes wrong..

[#9]

no problem glad to be of help.

To help explain it is basically using the boolean logic of your % calculation, which when you do Sum(exp)<0 returns you a 0 for false -1 for true.

By aggregating this by your customer field you effectively get a 0 or -1 for each customer.

Can then just sum that up and *-1 to flip the number

hope that makes sense

[vinafidalgo]

Please check if it's right

[#11]

Should be fine to just flip it to positive