Hi, all. Does anyone have experience on getting the quantity invoiced from the last 30 days from the time when it was last invoiced (so if it is last invoiced on 2/28/2021, it will go back 30 days prior to that). We are trying to do this in order to calculate the run rate, but in saved search, we can get the last invoiced date by trandate with summary type of MAX, but apparently, it won’t allow us to do the calculation like {trandate} - MAX({trandate}) because we assume the summary operation cannot do arithmetic with regular expression.

I did a similar calculation to provide a customer’s daily consumption of a consumable product that we sold. In our case we took the three most recent transactions. Sum Quantity / Max Date - Mid Date. Similar but slightly different