Skip to main content
Solved

GI - Formula calculation result not included decimal number.


Forum|alt.badge.img

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.

Best answer by sweta68

Hi @yansiongyu54,

I have reviewed your Generic inquiry formulae,

I suggest to use below formula for the  calculation.

=CDEC(MAX(DateDiff('d',[POOrder.OrderDate],[POOrder.ExpectedDate])))/(COUNT([POOrder.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

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+10
  • Semi-Pro III
  • 229 replies
  • Answer
  • August 29, 2023

Hi @yansiongyu54,

I have reviewed your Generic inquiry formulae,

I suggest to use below formula for the  calculation.

=CDEC(MAX(DateDiff('d',[POOrder.OrderDate],[POOrder.ExpectedDate])))/(COUNT([POOrder.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


Forum|alt.badge.img
  • Author
  • Freshman I
  • 16 replies
  • August 29, 2023
sweta68 wrote:

Hi @yansiongyu54,

I have reviewed your Generic inquiry formulae,

I suggest to use below formula for the  calculation.

=CDEC(MAX(DateDiff('d',[POOrder.OrderDate],[POOrder.ExpectedDate])))/(COUNT([POOrder.OrderNbr]))

Let me know this will resolve your issue.

Regards,
Sweta

Hi, thank you for your reply, it is solved,



 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings