Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Calculate cumilative sum for date

Hi,

I want to calc cumilative  sum of sales , mentioned as desired output in the below table

 DateSalesDesired Output
Min Date11/25/20185050
 11/26/20184696
 11/27/201867163
 11/28/201842205
 11/29/201838243
 11/30/201825268
Max Date12/1/201861329

 

Appreciate your help 🙂

1 Solution

Accepted Solutions
jfkinspari
Partner - Specialist
Partner - Specialist

Within a table you can use

RangeSum(Above(Sales,0,999))

View solution in original post

2 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

Within a table you can use

RangeSum(Above(Sales,0,999))

Frank_Hartmann
Master II
Master II

Or may be like this:
Rangesum(above(Sales, 0, RowNo(Total)))