0 Replies Latest reply: May 12, 2017 1:19 PM by Michel Coolen RSS

    How to summarize a calculated field in which a variable has been used...

    Michel Coolen



      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.