Cognos Insight - Custom calculation

[gujsa01]

Hi,

My first attempt to use Insight here.

Got through loading fact and building dimensions using fact SQL successfully.

Trying to add Custom calculation by right clicking on a column->Calculate->Custom to add the following:
IF (DB(..) > 2, 'HIGH', 'LOW');

Errors out.

Is this possible using Custom Calculation or have to define rule using Architect?

Appreciate any help.

Thanks,

Sameer Gujar

[gujsa01]

Resolved.

Just insert the right hand side of the rule and exclude area definition.