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

    Set Analysis - Sum with date range

    DANIEL ARAUJO

      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:

       

      =SUM(IF(vData_Fup>=data_fup,QTDE_PLANEJADA-QTDE_ENTREGUE,0))/sum(QTDE_PLANEJADA)

       

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

       

      Thaks in advance!

       

      Regards,