comparing values

[Anonymous]

Hi

I have 2 values 99.900% and the other is 99.7 in the database , I need to compare these two value to color a cell , if first one is greater than 2nd green else red, so when I convert the following number using num as 99.700%  or vice versa the color does not change , how do I make both in same format and make sure the color coding works ?

Thanks

[Gysbert_Wassenaar]

Try multiplying the 99.000% with 100 or divide 99.7 by hundred so they are of the same order.

[#3 · Accepted solution]

You should first convert the text value(99.900%) to a number so that it can be compared to the numeric value (99.7) using the following: num(PurgeChar('96.900%','%'),'#.0');

Do this in the LOAD operation. For example, if the column name is Score:

Load

num(PurgeChar(Score,'%'),'#.0') as Score

[MarcoWedel]

Hi,

this seems to be possible as well:

hope this helps

regards

Marco