3 Replies Latest reply: Aug 23, 2016 5:40 AM by MARCO HADIYANTO RSS

    issue

    Joanna Seldon

      Hi

       

      have issue with colour of background expression , with percentage calculation

       

        if(sum([Processed In 8 Hours])/SUM([Total Customers])>= 1, green(), yellow())

       

      I am using this on a table chart.

       

      issue I have that on a Date that the percentage is 99.32%...because of this it will colour the background yellow. I need to only if exact 100.00% it is yellow

       

      I need the percentage to show in this format, so rounding is not an option

       

      please help