Business Query

ShreyaSharma

Hi ,

Anyone please take a look..

I need to input this formula..so that it should not overlap the next formula..how to do it ...

IF [A]!=0 AND [AT]= "0" THEN "ABD" ELSE "" ENDIF

 

if [STM]="DSW" THEN "BDC" Else"" ENdif

 

IF [ASW]=0 and [DFS]<5 THEN "DS"  ELSE "" ENDIF

 

IF [SSMD]<5 THEN ""FGHFHR"ELSE "" ENDIF

grazitti_sapna

Is this what you are trying to achieve? 

If yes then I believe the formula you are using is correct just need to change the priorities as you can see the row 4 satisfy the criteria Manual !=0 and GT-Manual=0 that is why it takes the status as Open Item just switch line 1 and 2 and it will work as it will give first priority to Record MJE then although it satisfy the condition mentioned earlier.

Also you need to prioritise the if else condition if two rows satisfy same condition and you are applying another condition to the same row then priority should be given as per the logic or end result you are looking for.

I hope this solves your query.

If yes, then kindly mark this post as solution.

IF [Right_SO-Fset-Eset]= "Reserve for Parts--" THEN "Record MJE" elseif [Manual]!=0 AND [GT-Manual]= 0 THEN "Open item" Elseif [SL Solution]="Aged item-Reservs booked with no amortization for 180 days from ATD1" THEN "Open Item-Aged" Elseif [SL Total]=0 and [Grand Total]<5 THEN "Open item_Closed order" Elseif [Grand Total]=0 and [SL Total]=0 THEN "Open item_Closed order" Elseif [GL vs SL]= 0 THEN "Record_Matched" Elseif [GL vs SL] > 5 THEN "Open Item" ELSE "" ENDIF

Thanks.