5 Replies Latest reply: Jun 4, 2018 9:27 AM by PAUL STURMEY RSS

    Help on Set Analysis expression

    PAUL STURMEY

      Hi All

       

      Could someone help me on syntax for a set analysis expression

      The purpose is to calculate sales value for Year to date.

       

      The expression below works OK but as you can see I've hard coded the month values

      Month 1 is OK as that will never change but I need a way to get current month value

      So for example how to I replace 6 with a function or variable?

       

      if(vDateRangeSelection = 'YTD',

      Sum({1<Month = {">=1 <=6"},

      [Year]={'2018'},

      [Customer Type]={"External"}

      >} [Potential Value])*vCurrencyRate,))

       

      any help appreciated

       

      Paul