BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
saitcopuroglu
Community Trekker

CumSum with more than one variable

Need some help here.

I have this script for Cumulative Summary of NetRoomRevenueWithoutVat column by Year.

I would like to add another or two variable let's say by Year and By Agency and By Location (could be character or numeric).

Thank you in advance

If( Row() == 1 | Lag( :Year ) != :Year,

  :NetRoomRevenueWithOutVat,

  Lag( :CumSumByYear ) + :NetRoomRevenueWithOutVat

)

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User ms
Super User

Re: CumSum with more than one variable

If the table is adequately sorted, I think this formula could work:

If(Row() == 1 | Lag(Eval List({:Year, :Agency, :Location})) != Eval List({:Year, :Agency, :Location}),

    :NetRoomRevenueWithOutVat,

    Lag(:CumSumByYear) + :NetRoomRevenueWithOutVat

)

4 REPLIES 4
ms
Super User ms
Super User

Re: CumSum with more than one variable

If the table is adequately sorted, I think this formula could work:

If(Row() == 1 | Lag(Eval List({:Year, :Agency, :Location})) != Eval List({:Year, :Agency, :Location}),

    :NetRoomRevenueWithOutVat,

    Lag(:CumSumByYear) + :NetRoomRevenueWithOutVat

)

saitcopuroglu
Community Trekker

Re: CumSum with more than one variable

Thank you Michael! Would this help? michael@jmp

8349_Screen Shot 2015-03-13 at 14.02.26.png

0 Kudos
ms
Super User ms
Super User

Re: CumSum with more than one variable

It might. But what the optimal sorting would look like depends on the structure/hierarchy of your data. Only you can tell.

Btw, I'm not Michael...

0 Kudos
saitcopuroglu
Community Trekker

Re: CumSum with more than one variable

Ohh I am sorry!!! Really Sorry!! I thought you are Michael Crotty Mixed the MS with MC

Thank you a lot!

0 Kudos