Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if (match([Investor],'FNMA'),
if (match([Product Type],'HMP' and FTPMBM >= [Loss Mit Status Change Date]),’Y’,
if (Match([Product Type],'MOD24','APOLLO','ALT2011','ALTMOD','CAPMOD'),'N'))) as [IDI],
/*I
if (match([Investor],'FHLMC'),'N')as [IDI],
if (match([investor],'VA','PRIVATE / REG AB'),'Y')as [IDI],
if (match([investor],'FHA'),
if (Match([Product Type],'HUDMOD','HUDPCLM'),'N',
if (Match([Product Type],'FHAHAMP'),'Y'))) as [IDI],
You need to close ) after the match
if (match([Product Type],'HMP' and
replaced by
if (match([Product Type],'HMP') and
Some of my statements did not save. I am getting not enough argument errors here. My question here is must I use a 'Y','N' for each scenario to avoid the not enough arguments error
You need to close ) after the match
if (match([Product Type],'HMP' and
replaced by
if (match([Product Type],'HMP') and
Hi, in 2nd 'if' you need to close the match function and remove the ')' before 'Y':
if (match([Investor],'FNMA'),
if (match([Product Type],'HMP') and FTPMBM >= [Loss Mit Status Change Date],’Y’,
if (Match([Product Type],'MOD24','APOLLO','ALT2011','ALTMOD','CAPMOD'),'N'))) as [IDI]
Ok I will try it
It doesnt look like you closed your match statement on the second line "if (match([Product Type],'HMP'