Linechart ratio expression but it looks for previous month

[kstakpcn]

Hello all,

I would like to create a line chart which calculates a ratio. The formula is NPE/NPE_Total, however, the NPE is for the current month lets say December 2019 and the NPE_Total refers to the previous period, November 2019. Would that be possible to do in an expression?

Attached is an excel file with the formula. 

Thank you kindly for any suggestion!

[chrismarlow · Accepted solution]

Hi,

You need to use ABOVE function, so something like;

Sum(NPE)/Above(total sum(NPE_Total))

or;

Sum(NPE)/Above(sum(NPE_Total))

Use of the total in bold depends on how many dimensions you include in this & this will be sensitive to how it is sorted.

Cheers,

Chris.

Cheers,

Chris.