show sum OR which is less than 0

[StacyCui]

Hi, I want to calculate the sum value whose  the difference value is less than 0 in two year.  Here comes my function, but it shows -, if I changed into >0, it will show the value, what's wrong with it?

if(sum(aggr($(V_CY Till_OR)-$(V_PY_Till_OR),CNOC))<0,sum(aggr(($(V_CY Till_OR)-$(V_PY_Till_OR)),CNOC)))

[vinieme12]

can you post a screenshot from the expression editor?

also what are variables  V_CY Till_OR  and  V_PY_Till_OR

[StacyCui]

Pls take a look. Thank you so much

[StacyCui]

if I changed into >0, It will work. like below

[StacyCui]

If I select a customer whose difference value is  less than 0, this function will show the value, if I don't select , it will show -

if(sum(aggr($(V_CY Till_OR)-$(V_PY_Till_OR),CNOC))<0,sum(aggr(($(V_CY Till_OR)-$(V_PY_Till_OR)),CNOC)))

[vinieme12 · Accepted solution]

Try below

=sum( aggr(

 if(  $(V_PY_Till_OR)> $(V_CY Till_OR),$(V_CY Till_OR)-$(V_PY_Till_OR) )

,CNOC))

[StacyCui]

wow, It works. But  What's the reason?