issue

[joeybird]

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

[sunny_talwar]

How about this:

If(Sum([Processed In 8 Hours])/Sum([Total Customers]) = 1, Yellow(), Green())

[joeybird]

Hi

no sorry, still happens,

its like if its rounding the 99.32

please help

[marcohadiyanto · Accepted solution]

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