Need Help On Set Analysis

[ashfaq_haseeb]

Dear all

I have 5 years of data in my application.

I need to calculate few dimensions like sum(amount Received) etc for specific two years. based on time calender. If nothing selected then it should consider it as a current year for which i use if with setanalysis

I have a straight table with gls class as dimension

expression is as follows

if(year,sum({Year=Year>} Price),sum({$(Year)= { $(vCurrentYear)}>} Price)

where year is comming from master calander and vCurrentYear is a variable which hold current year value

this give me exactly what i want

now what I want is I need to divide Price of each gl class by total price of all gl class which is calculated in first dimension.

o/p of straight table is

GL CLASS VALUE VALUETOBECALCULATED

01 5 5/1500

02 10 10/1500

.

.

0N 1500

how to acheave this

Thanks and Regards

ASHFAQ

How would i do this

I tried this

[ashfaq_haseeb]

any one can please reply on this issue

[pover · Accepted solution]

Ashfaq,

Try using the total keyword. For example, sum(Price)/sum({$<[GL CLASS]={'0N'}>} Total Price).

Regards, Karl

[ashfaq_haseeb]

Thanks Karl

It worked out.

I thanks a ton. Every time you helped me a lot.