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

    Set Analysis Syntax Error

    Riley MacDonald



      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



      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