Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Joanna,
try this for your background color and just use your measurement for your value
if(ceil(sum([Processed In 8 Hours])/SUM([Total Customers]))>= 1, green(), yellow())
Regards,
Marco
How about this:
If(Sum([Processed In 8 Hours])/Sum([Total Customers]) = 1, Yellow(), Green())
Hi
no sorry, still happens,
its like if its rounding the 99.32
please help
Hi Joanna,
try this for your background color and just use your measurement for your value
if(ceil(sum([Processed In 8 Hours])/SUM([Total Customers]))>= 1, green(), yellow())
Regards,
Marco