Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm tryng to solve one expression.
When I use the expression =SUM({<DATA={">=$(=MAX(DATA,12))<=$(=MAX(DATA))"}>}MBB_CREDITO)
/
AVG(Aggr(SUM({<DATA={">=$(=MAX(DATA,12))"}>}RISCO_TOTAL), DATA)) in a KPI it works, I should SUM the last 12 months accumulated of MBB_CREDITO and DIV by Avg of the SUM of last 12 months RISCO_TOTAL acumulated
But when I put it on a line chart, or filter another month It doesn't work.
Can you guys help me?
What is it doing now?
RangeSum(Above(Sum(MBB_CREDITO), 0, 12))
@antoniodneto wrote:
And now I need to add the avg for this expression.
Is that a question for me or do you already know how to do this?
Hi Sunny,
That was a question but I solved. Tks again!!
If you could help me with a new one question that I just created, I would be great.
Tks a lot, always saving me.
Hi @sunny_talwar !!
I'm using your expression that you helped me:
RangeSum(Above(Sum(MBB_CREDITO), 0, 12))
I have DATE values from JAN/2016 until DEC/2018, but I just need to show starting from DEC/2016.
So now I'm using
RangeSum(Above(Sum({<DATE={">=DEC/2016"}>}MBB_CREDITO), 0, 12))
It works on graph starting DEC/2016, but is calculating wrong because it seems "excluding" the previous months. How can I fix that?
Try this
RangeSum(Above(Sum(MBB_CREDITO), 0, 12)) * Avg({<DATE={">=DEC/2016"}>} 1)