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))