Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Would you be able to share a sample of your app with the expected output you would want to see?
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