3 Replies Latest reply: Aug 23, 2016 5:40 AM by marco hadiyanto RSS


    Joanna Seldon



      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