TM1 Forum

Hi All!

Dimension:Time ( months, years), dimension with measures( sales quantity, percentage)

At the moment I have been trying to write a rule to calculate a percentage for each month based on the total year quantity ( month/year = %), where each year should be 100%,
however, I do not know how to make level based calculations in TM1 rules, so I would not have to write it separately for each year.

Could anyone please give me peace of advice if there are other ways how to perform that in rules?

Thank You

Regards

Danielle

Please provide the actual rules, as well as screenshots of the dimensions and cube involved.

I might be reading your question wrong but wouldn't something simple like this work:


['Percentage'] = N: ['Quantity'] / DB( 'Cubename', ELPAR( 'Time', !Time, 1 ), 'Quantity' ) ;

FEEDERS;

['Quantity'] => ['Percentage'] ;



If this works then I really recommend you read through OF the basics. Try the online courses that IBM produces. Or borrow a copy of the TM1 cookbook from the library.