Nested if

Question

Hi,

I have 3 formulas  that needs to be executed in sequence to find the value fo LT

1. If AD-DD < 0 then SD-DD else AD-DD

2. If SD-DD < 0 then ED-DD else SD-DD

3. If ED-DD<0 then '1' else AD-DD

If tried to use If and Else if , but its not working . Can some help to build this in one queruy.

Thanks

OllieClarke · Answer

Hey @praneshsapmm I think this is what you want:

IF [AD-DD]<0 AND [SD-DD]<0 AND [ED-DD]<0 THEN 1

ELSEIF [AD-DD]<0 AND [SD-DD]<0 THEN [ED-DD]

ELSEIF [AD-DD]<0 THEN [SD-DD]

ELSE [AD-DD]

ENDIF

Hope that helps,

Ollie

ShankerV · Answer

Hi @praneshsapmm

Can you share the sample input and expected output.

Based on that, can modify the function.

praneshsapmm · Answer

hi @ShankerV ,

I tried to build this in one query , but if it meets first condition , loop ends there , i want it to check the other condition as well .

I do not want to create too many formula so try to meet the reqiurements in same query .

Thanks