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

    set analysis issue

    antoine beck

      Hello,

       

      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.