Hi @yansiongyu54,
I have reviewed your Generic inquiry formulae,
I suggest to use below formula for the calculation.
=CDEC(MAX(DateDiff('d',dPOOrder.OrderDate],ePOOrder.ExpectedDate])))/(COUNT(NPOOrder.OrderNbr]))
Please note I have changed the field in Formulae as I don't have your custom field. so change it accordingly.
Let me know this will resolve your issue.
Regards,
Sweta
Hi @yansiongyu54,
I have reviewed your Generic inquiry formulae,
I suggest to use below formula for the calculation.
=CDEC(MAX(DateDiff('d',dPOOrder.OrderDate],ePOOrder.ExpectedDate])))/(COUNT(NPOOrder.OrderNbr]))
Let me know this will resolve your issue.
Regards,
Sweta
Hi, thank you for your reply, it is solved,