Average value for Quarter - Dynamic

[nikhil_cr]

Hi, I'm trying to calculate avg value for each quarter based on the current Month completed.

I have the below table and I'm trying to calculate the Avg value for each Quarter.

Avg Revenue for Quarter Q1 = (1+2+3)/3

Avg Revenue for Quarter Q2 = (4+5+6)/3 and So on....

Let us assume we are in November, then the avg revenue should be - 
Quarter Revenue Average Q4 = (10+11)/2 (diving by 2 here because December is still not completed)

How can I make this divisor dynamic based on the months completed for each quarter.

 Appreciate your help, thanks.

[Spd_03]

Hi @BrandonR, 

Even we've tried this way but it's not working.

[anurag]

Hi,

Can you use table resultset to prepare the data (construct a Quarter column from Month) and then use the solution proposed by @BrandonR ?