Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
Below is my condition :
if (sum(Act)<sum(AOP),lightred())
This is user requirement to show data upto 1 decimal , but if I'm doing this , I'm getting red colors if Act = AOP
but from the second picture this is clear than Act value is less than AOP and hence showing red numbers.
How can I handle color based on format , just want to show upto 1 decimal.
So in case of KHE "95.2%" should be black and not red.
Thanks,
AS
May be this:
If(Round(Sum(Act), 0.001) < Round(Sum(AOP), 0.001), LightRed())
UPDATE: I am sure if Act and AOP are percentages or not, but the idea is to use Round() function here. To what place to round it to, you can decide based on your data (either 0.1 or 0.001)