Hi All,
I hv a report which has acct_no,loan_period,cal1,cal2 columns.
For one acct_no there are two loan_period's eg. for acct_no 101 has two laon period i.e. 2006 and 2007.Now i want to perform cal3 which is as below :-
cal3 = (value of cal1(2007)- value of cal2(2006) )/ value of cal2(2006)
I m not sure hw I will carry out such a calculation.
Plz suggest.
Thanks,
Dipsy
Dipsy,
You can break down your calc 3 into multiple parts.
Step 1: Create Query Item Calc4 = (value of cal1(2007)- value of cal2(2006) )
Step 2: Create Query Item Calc5 = value of cal2(2006)
Step 3: Create Query Item Calc3 = Calc4/Calc5
In this way you have all the values if required in future for other calculations (permutations/combinations).