2 Replies Latest reply on Nov 30, 2015 9:35 AM by Hope Stiles

# Conditional calculation issue.

I am trying to create a calculated field with condition, example Time in Seconds , IF  (T>0) then 'Positive'  Elseif T>100 then 'Extream' Elseif T = Null or T<=1 then 'Negative' ;  It should suppose to show 3 categories Positive and Extream and Negative. but for me it's showing only Positive and Negative only It's not showing Extream. Please Help me in this conditional statement issue.

• ###### 1. Re: Conditional calculation issue.

Sudha,

All the T > 0 will fall into the 1st bucket because you are not justifying the extreme bucket. So try something like:

IF T>0 and T<100 then 'Positive'

ELSEIF T>100 then 'Extreme'

ELSEIF T = NULL or T <=1 THEN 'Negative'

END

If it doesn't work, I suggest attaching some sample data along with the expected results.

Pooja.

1 of 1 people found this helpful
• ###### 2. Re: Conditional calculation issue.

You might want to add something for when T=100.  I don't know if the goal would be for that that to be Positive or Extreme.

1 of 1 people found this helpful