?

[xyz1]

.

[Anonymous · Accepted solution]

Try this,

IF("Schedule Variance">='0%', ' Ahead Of Schedule',IF("Schedule Variance"<'-10%', 'BehindSchedule','On Schedule'

          )) as Schedule_Classification

[Anil_Babu_Samineni]

Normally percentage calculate in Decimal like 10$ - 0.1 and so on. I assume, In your case it has like below

IF("Schedule Variance">=0.0, ' Ahead Of Schedule', IF("Schedule Variance"=1, 'On Schedule',  IF("Schedule Variance"< (-0.1), 'BehindSchelule'))) as Schedule_Classification

[Anonymous]

Try this...

IF("Schedule Variance">='0%', ' Ahead Of Schedule',

IF("Schedule Variance"<='-10%' and "Schedule Variance" <'0%','On Schedule',

IF("Schedule Variance"<'-10%', 'BehindSchelule')

          )) as Schedule_Classification