5 Replies Latest reply: Oct 16, 2015 3:18 AM by Robert Mika RSS

    Background Color Expression with NULL Values

    John Koegel



      I would like to have the background color for a pivot table that has NULL values in a calculated dimension field     


      if((Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt)) > 0, Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt), 0)



      Here is what I was thinking:


      Colormix1(if((Sum(SalesAmt)/Sum(Total<[Region],[SalesRepName]>SalesAmt)) = 0,0), red() , white())


      I am seeing "-" as opposed to 0, and I think this is causing my colormix function to fail.