Skip to main content
Member
Apr 8, 2025 1:01 AM UTC
Solved

Average 12 months Account formulas

Hi everyone, I suspect that this is fairly simple, but I haven't been able to find a solution as yet.

I need to add formulas for Debtor Days, Creditor Days, and Inventory Days, all of which use 12-month averages in the calculation. The also all use the number of days in the month.

Does anyone have an example of the syntax needed to include both of these?

Thanks

chulAnswer
Employee - Guide
May 6, 2025 6:53 PM UTC

Are you able to use V#Trailing12MonthAvg?

2 replies

chulEmployee - GuideAnswer
Employee - Guide
May 6, 2025 6:53 PM UTC

Are you able to use V#Trailing12MonthAvg?

Member
May 18, 2025 11:12 PM UTC

Thanks Chul, this works.