Hello, I am trying to add a custom field on the Items list that shows the Monthly Average Quantity for the Last 3 Months.
I am trying to achieve this by adding a FlowField to the items list that sums all the negative quantities in the item ledger entry, multiplies it by -1 (to get a positive number), and then divides by 3 (to get the average of 3 months) with a date filter for the past 3 months. However, I am having trouble writing the CalcFormula for this.
Can someone please provide some suggestions and/or code samples to achieve this? Any help would be greatly appreciated. Thank you!
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
297
Share
Report
All responses (
Answers (
