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?

       

      Thanks!

      Ian