if condition

[upaliwije]

Hi

if (REM='NOT',YEAR=NUM(YEAR+1),YEAR)AS YEAR

I have above script in my data load script . but It returns ) when the REM=NOT but when REM=YES it is correctly updates as follows

pls advise where I have mad the error

REM   YEAR

YES     2012

NOT      0

YES     2013

[kkkumar82]

Hi Upali,

As per your script

When the REM value is NOT the year value will return 0 and if it Yes then it would return the same value in year,

Is that what you want.

Please find attached qvw and let me know ur actual requirement.

Thanks

Kiran Kumar

[kkkumar82]

Attached file

[upaliwije]

Thanks

What I want is to add 1 to year if REM=NOT 

Eg if year=2012 and rem=not   2013 should be returned

[kkkumar82 · Accepted solution]

Please find attached document, Hope it may help you.

Thanks

Kiran Kumar

[upaliwije]

Thanks

[kkkumar82]

Great to help you, your are welcome.

Thanks

Kiran Kumar