1 Reply Latest reply: Apr 17, 2018 5:05 AM by Poojashri Bangera RSS

    problem in max(Fiscalyear)

    Poojashri Bangera

      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