I am needing to create a formula for activity between two reload dates. I currently load a qvd weekly which gives me all data from a point in time (01/01/2018). As well as displaying statistics each week for that point in time I would also like to show the difference in numbers of the activity that occurred just between the two reload dates.
week1 - Total discharges 120
week2 - Total discharges 160
//I would like to create a new chart showing the difference of '40' as a figure.
example formula I have tried but didn't work: ED_DatePulled=('>=$(=(max(ED_DatePulled)-7))<=$(=max(ED_DatePulled))'