How can I use the total or subtotal in a calculation?

This topic contains 0 replies, has 1 voice, and was last updated by  Frank 1 week, 3 days ago.

  • Author
    Posts
  • #585
     Frank 
    Keymaster
    • Topics Started - 60
    • Replies Written - 49

    Stratum provides predefined calcs that can help out if you want to use either the total for a measure or the subtotal amount. To use the total there is a specific calc function you can use in the Stratum Viewer Functions. For the subtotal you can back into the subtotal amount from the Stratum provided % of Subtotal function. I’ve included a couple of screen shots to show how you can use both the #Total function and the #PercentOfSubtotal functions to see the totals or subtotals on each row. Of course if you are using these in a calc you’d hide these measures as they have no real value to a user on each row.

    Here’s the View – a simple example of getting the total and subtotal in the view:

    This is the calc for getting the Total into a measure you can use in calcs on each row:

    Last one – this is the two calc’s needed to get the Subtotal into a measure on each row so you do calcs with it:

    Any questions or comments post them here. Hope this gives you some ideas on how you can use different levels in calcs in Stratum.

You must be logged in to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

©2020 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials

or    

Forgot your details?