Posts by nil_s85

  • Running Total Reset based on condition

    Hi,


    I have a list of items packed in cartons , each with their total volumes. I have created a separate column CUM_VOL to calculate the running total of their volumes. I am trying to create a new column , TEST which calculates the running total , but resets the running total, when the running total has exceeded or equal to a certain value 100000 .
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 569"]

    [tr]


    [td]

    CARTON_NBR

    [/td]


    [td]

    UNITS_PAKD

    [/td]


    [td]

    SKU_ID

    [/td]


    [td]

    TOTAL_VOL

    [/td]


    [td]

    CUM_VOL

    [/td]


    [td]

    MAX CNTR VOL

    [/td]


    [td]

    TEST

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]1[/TD]
    [TD="align: right"]111637460[/TD]
    [TD="align: right"]29970[/TD]
    [TD="align: right"]29970[/TD]
    [TD="align: right"]100000[/TD]
    [TD="align: right"]29970[/TD]

    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]2[/TD]
    [TD="align: right"]111764178[/TD]
    [TD="align: right"]62160[/TD]
    [TD="align: right"]92130[/TD]
    [TD="align: right"]100000[/TD]
    [TD="align: right"]92130[/TD]

    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]2[/TD]
    [TD="align: right"]111768477[/TD]
    [TD="align: right"]62906.25[/TD]
    [TD="align: right"]155036.25[/TD]
    [TD="align: right"]100000[/TD]

    [td]

    Reset

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]1[/TD]
    [TD="align: right"]111965111[/TD]
    [TD="align: right"]29970[/TD]
    [TD="align: right"]185006.25[/TD]
    [TD="align: right"]100000[/TD]
    [TD="align: right"]92876.25[/TD]

    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]1[/TD]
    [TD="align: right"]111682229[/TD]
    [TD="align: right"]29970[/TD]
    [TD="align: right"]214976.25[/TD]
    [TD="align: right"]100000[/TD]

    [td]

    Reset

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]1[/TD]
    [TD="align: right"]111957787[/TD]
    [TD="align: right"]31080[/TD]
    [TD="align: right"]246056.25[/TD]
    [TD="align: right"]100000[/TD]
    [TD="align: right"]61050[/TD]

    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]1[/TD]
    [TD="align: right"]111763475[/TD]
    [TD="align: right"]31080[/TD]
    [TD="align: right"]277136.25[/TD]
    [TD="align: right"]100000[/TD]
    [TD="align: right"]92130[/TD]

    [/tr]


    [tr]


    [TD="align: right"]31957386874[/TD]
    [TD="align: right"]1[/TD]
    [TD="align: right"]112165379[/TD]
    [TD="align: right"]31975[/TD]
    [TD="align: right"]309111.25[/TD]
    [TD="align: right"]100000[/TD]

    [td]

    Reset

    [/td]


    [/tr]


    [/TABLE]

    Appreciate any help towards achieving this result.


    Thanks