Subsidiary Views - Ratio Formula

Highlighted
Community Boss

Subsidiary Views - Ratio Formula

Hi Team,

 

In both the Subsidiary views training video and in the Planual it mentions that Subsidiary views should be used where a ratio needs to be in the same module but doesn't full require full dimensionality 

 

Can anyone provide an example of this I'm I can't picture it

 

Thanks!

 

Mark

 

IMG1.PNG

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Subsidiary Views - Ratio Formula

@MarkTurkenburg ,

 

Hopefully the below helps...Essentially, it is using the summary method of Ratio (instead of Sum, Max, etc.)

 

2020-05-15_14-51-31.png2020-05-15_14-51-57.png

Highlighted
Community Boss

Re: Subsidiary Views - Ratio Formula

Nice 1 @rob_marshall!

 

Thanks - that makes sense

 

Always helps to see an example!

 

Mark

Highlighted
Valued Contributor

Re: Subsidiary Views - Ratio Formula

Basically, unlike filters, you can't reference a line item that is not in the same module for either the numerator or denominator of the Ratio summary method so you have no option but to include it as a subsidiary view (if it doesn't require the same dimensions of the module) 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Community Boss

Re: Subsidiary Views - Ratio Formula

Thanks for the detail @einas.ibrahim !