This content has been marked as final. Show 3 replies
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