2 Replies Latest reply: Jan 27, 2017 1:45 AM by S Satti RSS

    Set Analysis - Sum with date range


      Hi All,


      I am pretty new using set analysis and I would like a help from you to solve it.


      I have 3 fields and 1 variable. They are: Planned_Qtt, Received_Qtt, Follow_up_date (the fields) and vFollow_up_date (the variable).


      What I want is to set the date and the variable and return the value (Planned_Qtt-Received_Qtt)/(Planned_Qtt).


      For that I used the formula below, but it doesnt work:




      Does anyone know how to get the value using another expression?


      Thaks in advance!