Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm have the following
LOAD
dimension,
IF(condition,SUM(field),NULL()) AS aggfield
RESIDENT table
group by dimension
getting an expression error.
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
Maybe like this:
LOAD
dimension,
Sum(IF(condition,field,NULL())) AS aggfield
RESIDENT table
group by dimension