1 Reply Latest reply on Apr 24, 2016 8:27 PM by Bill Lyons

    Trouble comparing published fields with new ones

    Ian Teperman

      Hi, I have my data published in Tableau Server. I have a field that is :


      If [date1]>(if DATENAME('weekday',TODAY())="Monday" then [date2] ELSE [date3] END) and [date1]<[date4] then 1 END  .


      All dates are in string format and it works. It sums the users that made a purchase between those dates


      I now have to change 'date2' and 'date3' because the conditions have changed. I created new fields (which are not published to the server) and the formula doesn't work


      Any help?