3 Replies Latest reply: Sep 2, 2016 3:13 AM by Gysbert Wassenaar RSS

    Background color expression in pivot table

    Nishanthi Rajendran

      if((Count( {<[Module 1]={'Completed'}>}[user name]))

      /

      (Count( {<[Module 1]={'Completed'}>}[user name])

      +

      Count( {<[Module 1]={'Not Completed'}>}[user name]))

      <100.00,rgb(255,102,102),rgb(102,204,0))


      The above expression works individually but i if i give numerator the else part is not at all executed for background color expression?

      Is there any solution ?