problem in max(Fiscalyear)

[poojashribanger]

Hi,

I have table like this

FiscalYear

2016-2017

2017-2018

when i am trying below expression i am getting 26

previously it was working fine.

right(max(FiscalYear),2)

it should give me 18 i.e my max(fiscalyear) is FY18

Please help.

i have attached image

[sunny_talwar · Accepted solution]

May be try this

Right(MaxString(FiscalYear), 2)