Regarding Query calculation in Report Studio

[dipesh_mistry]

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

[nuknsltnt]

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).