Print Page - Calculation created from different fact columns showing blank/null values

Title: Calculation created from different fact columns showing blank/null values
Post by: saumil287 on 04 Jul 2018 09:15:44 AM

Hi All,

I am creating a calculation of % sales - coalesce(f1.factcol,0)/f2.factcol2, It is giving blank recs instead of 0 values.

I tried adding coalesce in denominator col also, Still the same issue.

Thanks
Saumil287

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: saumil287 on 04 Jul 2018 09:15:44 AM