4 Replies Latest reply: Dec 10, 2015 8:52 AM by Sebastian Lettner RSS

    Set Analysis Syntax Error

    Riley MacDonald

      Hi,

       

      I am trying to create an expression which is restricted to only sum when the calendar day in my data table equals the variable I have set via the load script called vLatestDay, however this is not working. Here is what I have in the expression:

       

      Calendar day = Date dimension

      vLatestDay = Variable date

      WH Stock = The value I am trying to sum

       

      Expression:

      Sum({$<[Calendar day]={'>=$(=vLatestDay)'}> } [WH Stock])

       

      Can you please let me know if the syntax for the expression is OK? It does not seem to give me the expected result

       

      Thanks,

      R