Hi can someone help me on this,
I got different results
My data is if dpd is greater than 1 and less than or equal to 30 then results will be 30
The ff are the scenario
:Previous data
Acct1 - dpd =30
If dpd >1 and dpd<=30,30,NA as prev_dpd
:Current data
Acct1 - dpd =28
If dpd >1 and dpd<=30,30,NA as curr_dpd
:Query to get the output
If prev_dpd = curr_dpd,'stabilized',NA as rollrates
The acct was classified as NA instead of statbilized
Thanks in advance