AGG Function with IF Statement

[Bansal_Kumar]

Hi Experts,

I have some values at Store and Item Level and I have to sum only those values which are greater than 500 at an aggregate level.

I did try the below code, But I am not getting the expected result. Please help.

sum(IF(AGGR($(value),COUNTRY,STORE,ITEM) > 500,AGGR($(value),COUNTRY,STORE,ITEM),0)

Please let me know if i am missing something.

[Kushal_Chawda]

@Bansal_Kumar  what is the expression in $(value)?

[sunny_talwar]

How about this

Sum(Aggr(
    If($(value) > 500, $(value))
, COUNTRY, STORE, ITEM))