2 Replies Latest reply: Jun 2, 2016 4:35 PM by Colin Albert RSS

    MonthSeqNum display 9598 wrong , how to make it display 2239 ?

    PAUL YEO

      Hi All

       

       

      Below expression for create MonthSeqNum work fine :-

       

       

      AutoNumber(num(year(TempDate)) & num(month(TempDate), '00')) as MonthSeqNum,

       

       

      Below expression also work fine but return 9598 :-

       

       

      sum({$<           year=,          month=,           MonthSeqNum = {"$(=only(MonthSeqNum-0))"} >}  Amount/$(Columndim89)/1000)

       

       

      May i know how to make it display 2239 ?

       

       

      Paul