Nested IF THEN and Greater than or Equals Statements - Unknown Variable

rgalik

Good Morning, 

I am trying to utilize this formula to compare data between two columns and then return a specific result. When I ran the formulas individually they worked fine, however they would read everything that didn't fit that formula as a 'Flag' 

Here is my formula. Am I getting something wrong with the syntax?

I have created a new column called 'Employee Hours Flag'

if [Hours] < 30000 AND [EMPLOYEE] >= 1 THEN ''
ELSEIF [Hours] < 69999 AND [EMPLOYEE] >= 2 THEN [Employee Hours FLAG]
ELSEIF [Hours] > 70000 AND [EMPLOYEE] >= 2 THEN [Employee Hours FLAG]
ELSE 'FLAG' ENDIF

afv2688

There is something bothering me: 

"""""""""""""""""""""""""""""""""""""""""""""""""""""""

I have created a new column called 'Employee Hours Flag'

if [Hours] < 30000 AND [EMPLOYEE] >= 1 THEN ''
ELSEIF [Hours] < 69999 AND [EMPLOYEE] >= 2 THEN [Employee Hours FLAG]
ELSEIF [Hours] > 70000 AND [EMPLOYEE] >= 2 THEN [Employee Hours FLAG]
ELSE 'FLAG' ENDIF

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

The colum you are creating on the formula tool (which I suppose is a new one) is the same one you are using on the formula itself? I mean, if it was there before then everything is ok, but if not you cannot use it.

On the other side, if I'm wrong and thats not the case the formula is well written. I did use it with some dummy data and for me it works.

Would need as I said some data or the error that the WF is giving you to help you further.

Regards