Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nam
Former Employee
Former Employee

burn down chart formula help

i have a total value for 6 months of 900, then i have monthly values month1:10, month2:20, Month3:20, ... etc. 

what i want to show on a graph is a decreasing value so month1: 900-10, month2:900-10-20, Month3:900-10-20-20 and so on. so the graph starts with the total at the first month and with each month the graph decreases. the formula im using is =TotalMS-rangesum(Above(sum(MileSBL))). the dimension on the graph is YearMonth.

Please help

1 Solution

Accepted Solutions
nam
Former Employee
Former Employee
Author

rangesum(Above(sum(TotalMSBL)0,rowno()))

Sorted

View solution in original post

1 Reply
nam
Former Employee
Former Employee
Author

rangesum(Above(sum(TotalMSBL)0,rowno()))

Sorted