Sum Aggr above the last 12 month

[Anonymous]

Hi guys

I have a problem with regard to making a cumulative sum for the last 12 months (from field Cap Op) from the maximum selection month, I have followed existing examples but I can not find the answer.

My expressions are:

Valores:

((sum({<conta_contabil ={'4*'}>}valor)-

sum({<conta_contabil ={'4191005'}>}valor))*-1)

Cap Op:

((sum({<conta_contabil ={'4*'}>}valor)-

sum({<conta_contabil ={'4191005'}>}valor))*-1)/IDI

Result (which does not work for me):

sum( aggr( rangesum( above(

(

((sum({<conta_contabil ={'4*'},[Año]>}valor)-

sum({<conta_contabil ={'4191005'},[Año]>}valor))*-1)/IDI

)

,0,12) )

,(Periodo,NUMERIC, DESCENDING)))

Please I ask for your support.

Thank you so much.

Greetings.

[Anil_Babu_Samineni]

Try this alone?

RangeSum(Above(((sum({<conta_contabil ={'4*'},[Año]>}valor) - sum({<conta_contabil ={'4191005'},[Año]>}valor)) * -1)/ID1, 0,12))

[Anonymous]

Nothing yet, I get 0 yet. I need to show the result in a text object.

[Anil_Babu_Samineni]

Can you attach QVW

[Anonymous]

Yes.