How I write If and If condition in Formula e.g
IF([CONTRACT_STATUS_CD]="1" AND [POL_PREV_STATUS_CD]="B")
then new_field=[POL_STAT_CHNG_DT]
else new_field=null
Provide some suitable example for above one
Rushikesh
Printable View
How I write If and If condition in Formula e.g
IF([CONTRACT_STATUS_CD]="1" AND [POL_PREV_STATUS_CD]="B")
then new_field=[POL_STAT_CHNG_DT]
else new_field=null
Provide some suitable example for above one
Rushikesh
Its the same as in Excel: AND is a function, and its arguments are the two conditions.
IF(AND([[x] = 1; [y] = 2)); "do some true work"; "do some false work")
I leave it as an exercise for the reader to adapt it to your own needs. ;)
I tried with this condition but couldn't get it run successfully...it continuously showed errors..not working for me.
How is your formula and what kind of errors. The formula from Taqua should by IF(AND(([x] = 1; [y] = 2)); "do some true work"; "do some false work")