3 Replies Latest reply: Dec 5, 2017 2:27 AM by john lewis

# if

Hi, i want to get this condition, where i am getting correct output for "ahead of schedule" and "Behind Schedule" but not getting correct results for:-

Schedule variance >= -10% to 0%, on schedule,

desired condition:-

Schedule variance>=0%, ahead of schedule

>= -10% to 0%, on schedule,

<-10%, Behind Schedule

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

IF("Schedule Variance"=1, 'On Schedule',               ------here i want 0% to -10%

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

))) as Schedule_Classification

• ###### Re: if

Try this,

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

)) as Schedule_Classification

• ###### Re: if

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

• ###### Re: if

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