How to use variable in IF statement

[#1]

Hi,

I'm bothering myself with one problem.

I would like to compare a value that I calculate and it is stored in variable with the Value from Field and then to color Background.

When I change the variable with inputed value it works fine, but with variable not.

What I am doing wrong?

This the End result.

variable value in text box

Is it problem with compare string and number? Or?

Please advice.

Thx

Tom

[Kushal_Chawda]

what is the expression for that variable?

Try to apply num function over expression like num(expression)

[#3]

Have already tried this and many other ideas.

Will try again.

Thx

[sasiparupudi1]

your formatting of the number is different to the value that is  being compared..

one is having . and another is having a comma..

you can not compare number with a string

fix it and it should work

hth

Sasi

[#5]

just a minute ago I've changed the Number format in properties.

Still no success.

I 'm aware the problem lies comeprrison.

How can I define that these two values are string?

thx

Tom

[sasiparupudi1]

you could may be try

num(replace('$(vX)',',','.'),'0.00')

where vX is your variable

[#7]

Just did it in Load statement.

I was loading dataset with comma, instead .

Will see result.

thx