Condiitonal aggregation

[markperrone]

I'm have the following

LOAD

dimension,

IF(condition,SUM(field),NULL()) AS aggfield

RESIDENT table

group by dimension

getting an expression error.

[Sohan_Patil]

Hi,

I think you get the same expression error as below for script. I am using measure sales in condition.

Error:

script:

If condition is changed to sum(Sales) as below it will work 

[vincent_ardiet_]

Maybe like this:

LOAD

dimension,

Sum(IF(condition,field,NULL())) AS aggfield

RESIDENT table

group by dimension