How to Calculate Running Totals by Key Field in Monarch Summary

Al_22614
Al_22614 Altair Community Member
edited May 28 in Community Q&A

Hello Team:

Could anyone advise how I may calculate a Running Total within a Subtotaled Key Field (Region).  I am familiar with using ****() for a whole report,  but I need the running total to apply within each Key field which is subtotaled.

image

Thanks in advance

Al

Tagged:

Answers

  • Nicholas_21406
    Nicholas_21406
    Altair Employee
    edited April 2023

    Hi Al,

    Please try the attached ****.dpwx(.txt), which takes an input file of Book1.xlsx, which looks like this: 

    image

    Transforms it using a Summary which is configured as follows:

    image

    and exports to a file which I have imaginatively called Sheet1$.xlsx

    image

    (Note you will need to rename ****.dpwx.txt to ****.dpwx in order to use it.)

     

  • Shelton Vance_22282
    Shelton Vance_22282 Altair Community Member
    edited April 2023

    Sorry that I don't have an answer, but I appreciate your directing me to the ****() function.  I needed that yesterday. :)

    SV

  • Al_22614
    Al_22614 Altair Community Member
    edited April 2023

    Thanks Nicholas: 

     

    Works very well in DPS.  Is it possible to do same with Monarch Classic?

    Thanks

  • Nicholas_21406
    Nicholas_21406
    Altair Employee
    edited April 2023

    Quite welcome.  I'm not sure if this could easily be done in Monarch Classic or not.  I would probably have to direct you to Professional Services, or else you could ask during our next Ask The Expert session, https://web.altair.com/ask-the-expert-monarch-series

  • Al_22614
    Al_22614 Altair Community Member
    edited April 2023

    Thanks Nicholas

  • Mahmoud
    Mahmoud
    Altair Employee
    edited May 2023
    Al_22614 said:

    Thanks Nicholas

    Please see attached zip file that shows how to create a summary in Monarch Classic for running total.

    Mo

Categories