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