its very urgent ( ytd ratio and avg ratio)

[anilkumar]

HI guys


([TOTAL REVENUEs]/[TOTAL EXPENSES])*-1   i used this formula created ine data item( rev/exp ratio)

but year to dat set working where as  actual ytd and avg running rate is not working.

eg: jan feb mar apr           actual ytd     avg running rate
      10% 20% 30% 40%       90%                90%/4=22.5

here  i used  queries like ?(1.aggregate(currentmeasure within detail [Year to Date Set4])
                                    2.aggregate([SPREAD (M)] within set [Actual],[Year to Date Set4])) 


for actual ytd. but is not working.

for avg running rate also i used average _ function.
but iam not able to solve this problem.



please provide solution  its very urgent.

thanks and regards
anil kumar