How to Apply two dimensions

Options
SPratt01
SPratt01 Member, ALL USERS Posts: 1 New Contributor
in Planning & Modeling

I'm creating a scenario model which is based on two measures.  I'd like my model to only apply a specific forecasted % to a row, if the measure is "total company" and profit share measure "Construction".  However, I cant use the NESTED IF function which I would use in excel as its not letting me use multiple items on the same dimensation.  This is the syntax I have so far:

 

IF ITEM(Profit Share Measures) = Profit Share Measures.Story Contracting Company Total THEN '(E1) Scenario Model'.Company % to Apply[SELECT: Total Company.CONSTRUCTION] ELSE '(E1) Scenario Model'.Profit % To Apply[AVERAGE: '(E1) Scenario Model'.Profit Share Measures]

 

To explain I want to bring through the forecasted % for each division of the company, however, in the total company I want to apply the company % forecasted for that specific division which may differ for each division.

 

 

 

 

Tagged:

Categories