Movingsum

DMManalili
DMManalili
in Modeling

Hi,

 

For your assistance please. I am trying to aggregate specific invoices and tried using the movingsum but on the last invoice cut off 4 which the number of days are variable. How can I count and use the movingsum? or is there another formula I can use? 

 

Example : August 2021

Invoice cut off 1 - starting 1st of the month until 7th of the month (fixed 7 days)
Invoice cut off 2 - starting 8th of the month until 15th of the month (fixed 8 days)
Invoice cut off 3 - starting 16th of the month until 22nd of the month (fixed 7 days)
Invoice cut off 4 - starting 23rd of the month until the end of the month (variable)

 

Thank you.

Tagged:

Answers

  • Ingilavicus
    Ingilavicus

    Hi @DMManalili ,

     

    If you need to reset the sum feature at a certain stage maybe CUMULATE() would work better, simply build a boolean formated rule on which days the sum should be reset. 

     

    Ingilavicus_0-1631600065329.png

     

     

    But from the example, I'm not entirely sure of the use case. 

     

    Andris

  • rob_marshall
    rob_marshall

    @DMManalili 

     

    Give TimeSum() a try in a different module where it is only dimensionalized by Invoices with the line items being the different cutoffs.

     

    Rob

Categories