11 Replies Latest reply: Jun 1, 2017 11:34 AM by antoine beck RSS

    set analysis issue

    antoine beck



      We try to figure out why our expression is not calculated :

      =sum({1<SAP_Period = {$(VCurrentPeriod)}>} Amount_CashCumul)


      where VCurrentPeriod is a variable and is : year(today())&'/'&num(month(today()),00)

      Displaying $(VCurrentPeriod) is 2017/05 and SAP_Period is in format YYYY/MM


      If we replace the expression by  =sum({1<SAP_Period = {'2017/05'}>} Amount_CashCumul) it is OK


      Any idea why? Thank you.