How to calculate A/R Turnover

Ask a Question

Hello

I am currently working on an accounts receivable dashboard. I am trying to calculate the Accounts Receivable Turn Over ratio which is

Revenue / ((Beg Bal. A/R + Ending Bal A/R) / 2)

So far to get ending balance I have this expression. Num(Sum({1}Balance),'$#,##0.##')

I imported the values for Total Revenue as "A" and Beginning Balance as "B".

I tried this but it didn't work.

(Sum(A)) / (((B) + (Num(Sum({1}Balance),'$#,##0.##'))

0 Replies