Author Topic: Calculation created from different fact columns showing blank/null values  (Read 87 times)

Offline saumil287

  • Statesman
  • ******
  • Join Date: Jan 2011
  • Posts: 288
  • Forum Citizenship: +2/-0
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

 


       
Twittear