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

    Background Color Expression with NULL Values

    John Koegel

      Hi,

       

      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.