Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this alone?
RangeSum(Above(((sum({<conta_contabil ={'4*'},[Año]>}valor) - sum({<conta_contabil ={'4191005'},[Año]>}valor)) * -1)/ID1, 0,12))
Nothing yet, I get 0 yet. I need to show the result in a text object.
Can you attach QVW
Yes.