Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
;
syntax error missing/misplaced from load
Not sure why I get this. I do not get any red brackets in the code. Is there a way to troubleshoot unexplained syntax errors
load
/*To format the IDI flag*/
if( (match([D Investor],'FNMA') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
(match([D Investor],'SunTrust') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
match([D Investor],'VA','PRIVATE / REG AB') or
match([D Investor],'FHA') and Match([Product Type],'FHAHAMP'), 'Y',
if( (match([D Investor],'FNMA')and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
(match([D Investor],'SunTrust') and match([Product Type],'HMP') and [Last FTPMBM Date] >= [Setup Date]) or
match([D Investor],'VA','PRIVATE / REG AB') or
match([D Investor],'FHA') and Match([Product Type],'FHAHAMP'),'N')) as IDI
*
;
load
if ([IDI]='N',trial4_due_dt= .,([4th Trial Made])= .),
*
;
Do you need a comma after as IDI
Do you need a comma after as IDI
Like Bill mentioned you need a comma after IDI but before the *. Also in your second load statement, you may need single quotes around the period in your if statement.
Thanks Bill
thanks