text color difference failling

[manoranjan_d]

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

[MarcoARaymundo]

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)

)

[vkish16161]

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))

[manoranjan_d]

its not working

[manoranjan_d]

its not wroking

[MarcoARaymundo]

if(Sum([Low USD]) = vMin and vMin = vMax,

RGB(0,0,255),

RGB(0,0,0)

)