Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following Data
Dimension : 2013 - 2012 - 2011
Expression: = above([Trade Receivables]) - ([Trade Receivables]
Now, when i run the formula and i select the dimensions 2011 - 2012 - 2013, i have the following results
2011 : -
2012 : 5.000
2013 : 7.000
How can I change the formula so that the data for 2011 dissapears ? I would like to select the data 2012 - 2013 in my dimenstion and obtain the same results as above without 2011.
thanks for you help in advance
working. Thanks a lot
Hi, you can try this:
RangeSum(above([Trade Receivables])) - Sum([Trade Receivables])
Best Regards
Tonial.