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

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

    M. Coolen

      Hello,

       

      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.

      Greetings,

      Michel