TM1 Forum

Hi everyone,

Iam new to tm1....

['Total Year','Quantity']=N:['Quantity']+['Projected']; This rule is not working in my view orcube,

I want the sum of quantity and projected quantity in the quantity element for 'total yr'(consolidated).

In Months dim under total yr there are jan,feb,.....dec. elements and for each element thaere are 2 measures Quantity and projected quantity.

I want the ummation of quantity and proj quanty only for total year element...rest all are base level except total year element........

Please suggest any alternate?

dilip wrote:Hi everyone,

Iam new to tm1....

['Total Year','Quantity']=N:['Quantity']+['Projected']; This rule is not working in my view orcube,

I want the sum of quantity and projected quantity in the quantity element for 'total yr'(consolidated).

In Months dim under total yr there are jan,feb,.....dec. elements and for each element thaere are 2 measures Quantity and projected quantity.

I want the ummation of quantity and proj quanty only for total year element...rest all are base level except total year element........

Please suggest any alternate?

Presumably "Total Year" is a consolidated element, yet by specifying "=N:" you are only applying the rule to N-Level cells.

Thank you.can you please suggest any alternate to achieve my objective.

Hi,

Can I suggest you take some time out to read (and understand) the documentation on rules.

That said you should really do what you want by creating a consolidation in your measures dimension that consolidates quantity and projected. In general never do sums (+ or -) in a rule sheet