Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a series of periods
2018Q1
2017Q4
2017Q3
.....
I want to be able to get the prior period. So to get the max period I am using for example
Sum(Period = {"$(=Maxstring(Period))"}Balance) but I cannot use
Sum(Period = {"$(=Maxstring(Period)-1)"}Balance)
Does anyone have any ideas on how to do this?
Thanks,
Mark