Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
my text color expression getting failed for below scenarios and expression
I have given the the below expression
if(sum({<[Comparison Date]={'$(vMin)'}>}[Low USD])<>
sum({<[Comparison Date]={'$(vMax)'}>}[Low USD]),RGB(0,0,255),RGB(0,0,0))
example
scenario 1: fail
if the value is same i m getting blue color example
Min Max
800 800
its showing color hence it getting failed
scenario 2: fail
if any ine date have 0 value means
Min Max
800 0
800 is getting blue color but 0 value is in black clor
scenrio 3 : pass
Min Max
800 400
these are showing blue color, this is passed
let me why its getting passed for third scenrio and failed for scenrio 1 and 2.
lety me know the way to resolve this issue
Hi, try round function.
if(Round(sum({<[Comparison Date]={'$(vMin)'}>}[Low USD])) <>
Round(sum({<[Comparison Date]={'$(vMax)'}>}[Low USD])),
RGB(0,0,255),
RGB(0,0,0)
)
Try this:
if(sum({<[Comparison Date]={'$(=vMin)'}>}[Low USD])<>
sum({<[Comparison Date]={'$(=vMax)'}>}[Low USD]),RGB(0,0,255),RGB(0,0,0))
For troubleshooting you can always try:
if(800=800,rgb(0,0,255),rgb(0,0,0))
its not working
its not wroking
if(Sum([Low USD]) = vMin and vMin = vMax,
RGB(0,0,255),
RGB(0,0,0)
)