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
Print
Go Down Pages1
User actions

saumil287

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
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite