Forum Discussion

edge9999's avatar
edge9999
Frequent Visitor
1 year ago

Running Total for Charges

I have a faily simple problem (I think) that i just cant get my head around.   We have numerous transaction lines, each with a dollar amount and a truck associated wtih them.    I'm trying to do a qu...
vivek31's avatar
vivek31
Icon for Resolver II rankResolver II
1 year ago

HI edge9999 ,

 

you can try this formula to find running total for charges

running total = 
var current_unit = MAX(VW_TICKET_LINEITEMS[Unit])
RETURN
CALCULATE(SUMX(FILTER(ALL(VW_TICKET_LINEITEMS),
                      VW_TICKET_LINEITEMS[Unit] <= current_unit),[Total Charges]))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.