IF Expression Error

[#1]

Hi,

we are trying a simple IF expression, we are not getting an error with the syntax but the results will not load.

It is simply:

if(Sum(Cases*-1>80),'80-100',if(Sum(Cases*-1>60),'60-80', 0))

We have tried numberous different expressions but cant seem to get it.

We are trying to group the values of the cases into sub groups of ranges.

The Cases value on the file is negative, thats why we are mulitplying by -1.

Thanks,

Gregg

[jonathandienst]

Gregg

If you use an aggregation expression like Sum() in a load statement, you will need a Group By clause after the From Clause that contains all the fields in the load statement that are NOT in aggregation expressions.

Something like:

     LOAD ....

          Sum(....)

     From Heatmap.xls (biff, .....)

     Group By [Week No], Product, ....

Hope that helps

Jonathan