2 Replies Latest reply: May 1, 2018 1:00 PM by Akshaya Aditya RSS

    Formula Help

    Thomas Williams

      Hi,

       

      Can anyone please advise what the issue is here with my formula syntax please as I can't get it to work.

       

      sum(if(match([Personal],'Ian','Tom'),[Personal]),({<DATE_START = {">=$(=yearstart(max(DATE_START)))<=$(=today())"},year=,month=,[CITY] = {'NY'}>} Total_Value)

        • Re: Formula Help
          Sunny Talwar

          Try this

           

          Sum({<[Personal] = {'Ian','Tom'}, DATE_START = {">=$(=YearStart(Max(DATE_START)))<=$(=Today())"}, year, month,[CITY] = {'NY'}>} Total_Value)

          • Re: Formula Help
            Akshaya Aditya

            Hi Thomas,

             

            You are using IF to find whether Personal is Ian and Tom but you are not using that within the expression. Below can be the correct expression

             

            1 . sum({<DATE_START = {">=$(=yearstart(max(DATE_START)))<=$(=today())"},year=,month=,[CITY] = {'NY'},Personal = {'Ian','Tom'}>}Total_Value)

             

            2. if(match([Personal],'Ian','Tom'),sum({<DATE_START = {">=$(=yearstart(max(DATE_START)))<=$(=today())"},year=,month=,[CITY] = {'NY'},Personal = {'Ian','Tom'}>}Total_Value))