Subsidiary Views - Ratio Formula

Options
MarkTurkenburg_*8288
MarkTurkenburg_*8288
in Modeling

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

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓
    Options

    @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

Answers

  • MarkTurkenburg_*8288
    MarkTurkenburg_*8288
    Options

    Nice 1 @rob_marshall!

     

    Thanks - that makes sense

     

    Always helps to see an example!

     

    Mark

  • einas.ibrahim
    einas.ibrahim
    Options

    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) 

  • MarkTurkenburg_*8288
    MarkTurkenburg_*8288
    Options

    Thanks for the detail @einas.ibrahim !

Categories