If you are unable to create a new account, please email support@bspsoftware.com

 

Calculation created from different fact columns showing blank/null values

Started by saumil287, 04 Jul 2018 09:15:44 AM

Previous topic - Next topic

saumil287

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