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
