Background color for an expression in a straighttable

[#1]

Hi Guys,

IF(Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]) < 0.96, RGB(250,0,0)
 ,
 IF(Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]) >= 0.96 and Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]) <= 0.985, RGB(250,150,0)
 ,
 IF(Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]) > 0.985 and Sum(DeliveryQuantity/[ST/KAR1])/ sum(OrderQuantity/[ST/KAR]) <= 1, RGB(0,150,0)
 ,
Null()
)
)
)

I have this code in a straighttable expression under Background color,

I wonder why 0.96 is still Red instead of Orange.

Any ideas?

Thanks

Sravan

[jonathandienst · Accepted solution]

Sravan

Is it possible that the value you see as displayed as 0.96 is actually something like 0.959? Your expression would colour that red.

Jonathan

[#3]

Hi Jonathan,

I found out exactly that. sometimes eyes dont see small things:-)

Thanks

sravan

[#4]

Hi Jonathan,

one more Q. How can I correct the Sum here in the expression service Level%? The 10,978,6 is not correct.

Regards

Sravan

[jonathandienst]

Sravan

This is a new question and should go in a new post - that way it might be able to help others with the same problem.

Anyway, it looks like you have sum of rows option selected as the Total Mode. Change to Expression Total, which is usually the correct one for %.

Jonathan

[#6]

HI Jonathan,

Thanks for your Answer. Apologies for starting in the same thread. Nexttime I will take care of Opening a new post.

Thanks again.
Sravan