max date in set operator

[#1]

I have the following dataset. I am trying to get the latest three_year_fund_stdv_prod by using the following formula but it doenst work

max(  {$<dte={"=$(=max(dte))"}>}    three_yr_fund_stdev_prod)

I think there is an issue with my set operator

three_yr_fund_stdev_test three_yr_fund_stdev_prod            dte

0.34665516783936           0.34665516783936                     2013-03-01

0.35967874969951           0.35967874969951                     2013-02-01

0.3737224266293             0.3737224266293                       2013-01-01

0.38559724159305           0.38559724159305                      2012-12-01

0.40008534514359           0.40008534514359                      2012-11-01

three_yr_fund_stdev_test	three_yr_fund_stdev_prod	dte
0.34665516783936	0.34665516783936	2013-03-01
0.35967874969951	0.35967874969951	2013-02-01
0.3737224266293	0.3737224266293	2013-01-01
0.38559724159305	0.38559724159305	2012-12-01
0.40008534514359	0.40008534514359	2012-11-01
0.41961577636668	0.41961577636668	2012-10-01
0.40834927175527	0.40834927175527	2012-09-01
0.32747649656431	0.32747649656431	2012-08-01
0.3536170318398	0.3536170318398	2012-07-01
0.38734653938453	0.38734653938453	2012-06-01
0.34044096144746	0.34044096144746	2012-05-01
0.3862629824046	0.3862629824046	2012-04-01
0.32897919493473	0.32897919493473	2012-03-01
0.081975707899139	0.081975707899139	2012-02-01

[CELAMBARASAN]

Check with this

max(  {$<dte={"=$(=Date(max(dte)))"}>}    three_yr_fund_stdev_prod)

[jagan]

Hi,

Check whether date format in dte and Date(max(dte)) returns the date in same format, if not convert the date format.

Try like this

=max(  {$<dte={"=$(=Date(max(dte)))"}>}    three_yr_fund_stdev_prod)

or

=FirstSortedValue( three_yr_fund_stdev_prod, -dte)

Hope this helps you.

Regards,

Jagan.

[kaushiknsolanki · Accepted solution]

Hi,

     You expression is correct. All you need to do is just remove =. Have a look at the below expression.

     max(  {$<dte={"$(=max(dte))"}>}    three_yr_fund_stdev_prod)

Regards,

Kaushik Solanki