11 Replies Latest reply: May 17, 2018 8:55 AM by Thomas Williams RSS

    Date Function

    Thomas Williams

      Hi, can anyone please confirm why my formula won't work, I think it's to do with the date?

       

      It worked using this formula

       

      Alt(sum({<[Country] = {'USA'}>}if(left(Period,4)='2018' and match(Lookup,'10tata'),Val,0))

       

      but now I want to change the date to YTD and no longer works

       

      Alt(sum({<[Country] = {'USA'}>} and (Period={"$(='>=201801<=2018' & Num(Month(Today()), '00'))"} and match(Lookup,'10tata'),Val,0))