Per loaded record (stock mutations) I defined a field called 'TimePeriod' in which I typed the following expression:
If( (vToday - Num( date_mutation)) <= $(nb_of_days_variable), mutation_quantity)
The result of this expression shows me the mutation_quantity per record if the difference between today and the mutation_date is smaller or equal than the number of day's I put into my variable (using a slider in the frontend). So far, so good.
What I now would like to do is summarize the field 'TimePeriod' per product in an other table within the same sheet but I do not know how to fix this.
I hope somebody has a solution for this issue ?
Thank you in advance.