Hi Eugene.

I trust you had a good Christmas!

I realised that with the update to V5.20, I lost a QuickReport I had made showing me income averages by month.

The QuickReport used as a data source NPLedgerByMonths containing Date, ID and Amount

That allowed me to show a graph of the averages by month

I rummaged a bit in the XAF Data Types, and although I did find a Ledger by months, it seems to be empty.

How can I display the average incomes by month, across all data?

I suppose I could use a calculated field from Invoice | Amount (base cur), with Date (Month-Year) as an argument, but I don’t want to just divide the sum by 12, I would like to have the average up to now.

Do you have any idea for a solution?

Thanks!

Lorenzo

PS The picture is from V.5.0.4