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?
RangeSum(Above(Sum(MBB_CREDITO), 0, 12))
=SUM({<DATA={">=$(=MAX(DATA,12))<=$(=MAX(DATA))"}>}MBB_CREDITO)
if yo put this one alone also it is not working??
you need to check AGGR using on which dimension and is it same as ur line chart dimension..
I think you might need to use RangeSum(Above()) or RangeSum(Below()) to accumulate the values in a line chart where month is used as a dimension. It would be easier to help if you are able to share a sample.
Sure, but help you how?
okay... so try using RangeSum(Above()) function and see what you get
Something like this
RangeSum(Above(Sum(MBB_CREDITO), 0, RowNo()))