Nulls treatment

[ranne_78]

Hello,

We recently migrated from cognos 7 series to Cognos 8. There were some calculations in our
catalog are based on if-nullnumeric function which is not exist in cognos 8. If anybody had
replaced this function using any workaround? database is SQL Server.

Ranne

[rockytopmark]

coalesce() is the equivalent

[ranne_78]

Hi Rockytopmark,

Thanks for your reply. Do you know any alternative function from Cognos side?

Thanks,

Ranne

[rockytopmark]

coalesce() is an available function in Cognos... Framework Manager, Report Studio, etc.