Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have months written as follows: 201301 (January 2013), 201302 (February 2013), 201303,.......
Is there any formula when editing the expression that can refer to the last perfiod by default (this would be 201303 in the example above) ? Taking into account the way I write the perdios it should be a formula that points to the highest number.
Please help !
dani
Can more specfic what you trying to say?
Dani,
You can do it either in the script to store your result into a variable,
or in the UI with FirstSortedValue(Month, -Month, 1)
Fabrice
Yes, sorry. I need a formula that gives me the numbers of revenues for the last period (whatever is the last period).
Try...
1) =FirstSortedValue(Period,-Period)
2) =Date(Max(Date#(Period,'YYYYMM')),'YYYYMM')
FirstSortedValue(Revenue, -Month, 1)
Fabrice