Hello!
I have been struggling to put together a report that calculates the average date difference between a Purchase Order Date and the first Receipt Date in a decimal format.
For example, on 9/1/2024, our company placed 52 POs, some of which were delivered the next day, while others took ten days. I was asked to return that average wait time for all 52 Purchase Orders that day.
I was able to create a custom relation and field to get the first receipt date, but when I enter a calculated field, I return a whole number.
(first PurchaseOrderReceiptsRel.ReceivedDate day - PurchaseOrderDate day)
I’m wondering if this is playing a factor in my inability to return a decimal value, because when I divide that difference by our DailyPOCount I only return 0.
((first PurchaseOrderReceiptsRel.ReceivedDate day - PurchaseOrderDate day) / DailyPOCount)
If I multiply that result by 100 I do see whole number data, but the inability to return a decimal is limiting my success. It seems that each time I try to adjust the custom relation or field, it returns 0.99 across the board.
I’m hoping someone can point me in the direction of returning a date-related calculation as a decimal value. Thank you!
