Calculate Average from current Quarter

[rfigueroa]

Hi, Im trying to get the correct value in the sample below

RoE = SUM(NetProfit) / SUM(Capital) * 12

And "Avg RoE" needs to be AVG(RoE) for the current Quarter,

ie: the correct value for 2018/Q1 = AVG(47.7, 89.3, 36.1) = 57.7%

I have try with Aggr, and RangeAvg( Before...) without success

How can I achieve this?

Thanks in advance

[agni_gold · Accepted solution]

Change you Avg ROE expression to below : 

=Avg(
Aggr(
(Sum( {<ID_Class = {5}>} Balance)
/
Sum( {<Class = {'Patrimonios'}>} Balance)
* 12),Month))

see attached file

[rfigueroa]

Thank You