working of condition

[ayush0306]

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?

[Saravanan_Desingh]

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],