Skip to main content
April 8, 2025
Solved

Average 12 months Account formulas

  • April 8, 2025
  • 1 reply
  • 0 views

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

Best answer by chul

Are you able to use V#Trailing12MonthAvg?

1 reply

chulAnswer
May 6, 2025

Are you able to use V#Trailing12MonthAvg?

May 18, 2025

Thanks Chul, this works.