Set Analysis - Sum with date range

[Anonymous]

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,

[sunny_talwar]

Would you be able to share a sample of your app with the expected output you would want to see?

[satheshreddy]

Hi Daniel,

in your EXP

vData_Fup>=data_fup  you had mentioned like this but we need to mention single quotation for data.

like below

vData_Fup>='data_fup'

Try the below Exp

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

Regards

Sathish