5 Replies Latest reply: Jan 14, 2017 7:29 AM by Sunny Talwar RSS

    Lesser than clause for variable, not working

    Shazad Nazir

      Hi Experts,

       

      A variable "CuurentYear" is declared as: Max(Right(FiscalYear,4)) -1 & '-' & Max(Right(FiscalYear,4))

       

      Works Fine:          Sum({<DOBStatus = {'C'},FiscalYear = {'$(=$(CurrentYear))'}>}DOBQty)

       

      then I tried to use < sign in below clause it just stop working:

       

      Does Not Work:      Sum({<DOBStatus = {'C'},FiscalYear <= {'$(=$(CurrentYear))'}>}DOBQty)

       

      Can somebody please help,

       

      Thanks & Regards,