Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what is the expression for that variable?
Try to apply num function over expression like num(expression)
Have already tried this and many other ideas.
Will try again.
Thx
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
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
you could may be try
num(replace('$(vX)',',','.'),'0.00')
where vX is your variable
Just did it in Load statement.
I was loading dataset with comma, instead .
Will see result.
thx