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]

nop.. nothing happens, total still 82..

[#3]

Hi all,

Anyone in the forum can help me found at the problem? @_@

[kamielrajaram]

Hi,

Can you provide the document with no selections included.

Thanks

Kamiel

[#5]

just unselect "always one selected", here you go

thank you,

[nikhilgarg]

HEy , try this:

Count(if([YTD Growth]< 0 , Stores))

May be Distinct won't work out here !!

[vinafidalgo]

Hi, I'm selecting the Year 2014 and getting 82.

The expected result is 26?

[#8]

Nop.. its still wrong, the right value is 26.. but with your exprss is 163

[#9]

hi Vinicus,

yeap.. thats correct, did you get the expression??

[vinafidalgo]

Not yet but I'm trying to figure it out.

[#11]

oh boy.. its hard lol, i just cant find it the right expression @_@