Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to add a calculated field in the data manager. This new column will contain an if formula with an AND and OR condition. However the set expressor in the data manager does not recognize AND/OR functions. Is there a trick to bypass this problem?
Regards,
Pascal
May be this
If(LOAD_Index >= 4,
If(LOAD_Index >= 12, 1, If(Right(Com_Code, 1) = 'e', 1, 0)))
What is your condition that you have to use?
This is the formula i want to add:
IF (LOAD_Index >=12 OR Right (Com_Code, 1) = 'e' and LOAD_index >=4,1,0)
May be this
If(LOAD_Index >= 4,
If(LOAD_Index >= 12, 1, If(Right(Com_Code, 1) = 'e', 1, 0)))
Thanks! This works perfect.