Hi,
I am writing below codes to get an expression (each month balance/first month balance. Here denominator is always constant i.e. first yr balance however, numerartor will change on balance specific to each month
With Min Yr:
((Sum({1<yymm = {'$(=Min(yymm))'}>} ((OPEN_BAL_AMT)))+Sum({1<yymm = {'$(=Min(yymm))'}>} ((CLOSE_BAL_AMT))))/2)
This code gives first month balance.
All Yrs:
(sum( {$<yymm = >} OPEN_BAL_AMT )+sum( {$<yymm = >} OPEN_BAL_AMT ))
This gives balance wrt to each month.
Now when I try to divide above two expressions, I am always getting first month balance and not other month balance.
Plz help.
Sunil
