Formula that points to the last date

[danialier]

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

[sunilkumarqv]

Can more specfic what you trying to say?

[#3]

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

[danialier]

Yes, sorry. I need a formula that gives me the numbers of revenues for the last period (whatever is the last period).

[MK_QSL]

Try...

1)      =FirstSortedValue(Period,-Period)

2)      =Date(Max(Date#(Period,'YYYYMM')),'YYYYMM')

[#6]

FirstSortedValue(Revenue, -Month, 1)

Fabrice