topic Re: working of condition in App Development

working of condition

ayush0306 — Thu, 11 Feb 2021 15:00:49 GMT

If(len("Subrogation Potential") = 0,'NA',
if(([MODELID] ='2'and SEGMENT_CHGCD = 'UP'and ([SEGMENTCD] = 'Sig. High' OR [SEGMENTCD] ='High') and SCOREDTS_FLAG = 1),'Y',
'N'))as [SUBRO Promotions],

how the above condition working?

Re: working of condition

Saravanan_Desingh — Sun, 14 Feb 2021 03:37:01 GMT

May be see this with indentation.

If(len("Subrogation Potential") = 0, 'NA', if(([MODELID] ='2'and SEGMENT_CHGCD = 'UP' and ([SEGMENTCD] = 'Sig. High' OR [SEGMENTCD] ='High') and SCOREDTS_FLAG = 1), 'Y', 'N' ) ) as [SUBRO Promotions],