pls tell me some solution if you know , i can call you if u have sol

[venu]

I have Problem here with obiee

 

 I have loan   from bank  for example its 100 rs and its interest rate is 5 % ( i.e 0.05 ) ,

 

and that bank gave loan of 1000 dollars for that month total ( Month level  of loan amount )

 

 and avg value of all loans in that month is  for example   6% ( ie .06 )

 

No what i have to caleculate is     for each loan    per month   wac  =  100* .05  +  1000 * .06

                                                                                                 --------------------------------------- this is value for each loan.

                                                                                                            100 + 1000

 

 

Now problem here is , when i did caleculation , its giving me  month avg value of wac but i need individual amount  value  ,,,

 

 

 and i have to check  howmany number of  loan having this value  < 3.25 and 4 - 6 and 7-9 and   10 + 

 

thisis my req .....   i was able to caleculate the  wac value but unable to get the