Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Try this,
IF("Schedule Variance">='0%', ' Ahead Of Schedule',IF("Schedule Variance"<'-10%', 'BehindSchedule','On Schedule'
)) as Schedule_Classification
Try this,
IF("Schedule Variance">='0%', ' Ahead Of Schedule',IF("Schedule Variance"<'-10%', 'BehindSchedule','On Schedule'
)) as Schedule_Classification
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
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