How can I make a YTD average?

DeepakK

Hello,

I am looking to get a YTD calc but I cannot use the YEARTODATE function because I need an average, not a SUM.

And previous years should calculate according to their months (i.e. I would see a full 12 month avg for 2023, 5 month average for 2024).

My initial thought is to use TIMESUM but am having trouble setting it up.

Appreciate any help.

TristanS

@DeepakK Can be done but depends on what the basis of the average is. For example, you are looking for the YTD average of sales. I would have the following line items / formula

In Sales Transaction module

Line Item	Formula
Sales Counter	1
Sales Value	<This is data ingested>
Period	<Calculated Week Time Period>

In module where you are doing your YEARTODATE function

Line Item	Formula
Sales Value	Sales Transaction.Sales Value[SUM:Sales Transaction.Period]
Sales Counter	Sales Transaction.Sales Counter[SUM:Sales Transaction.Period]
YTD Sales Value	YEARTODATE(Sales Value)
YTD Sales Counter	YEARTODATE(Sales Counter)
YTD Sales Average	YTD Sales Value / YTD Sales Counter