Skip to main content

Hi, I meet a problem when creating a GI, not sure why the result will not display decimal number result.

Here is the calculation.

=SUM(DateDiff('d',[POReceipt.UsrReceiptDate],[POOrder.ExpectedDate]))/(COUNT([POOrder.OrderNbr]))

 

The attached with the xml file.

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,



 


Reply