1 Reply Latest reply on Jun 14, 2012 2:29 PM by Tracy Rodgers

    Calculation to show only till end of Last Month

    . Jeffi.Sannapu@Wellsfargo.Com

      Hello - I am trying to show data only till the end-of-last Month. So that the trend report are always reported at the EOM. In Tableau V5 I Was ble to accomplish this by filter on the date field, seleting the 'Individual dates' type of filter, 'Use All' in the General tab, and use the following formula

       

      [Your Date] < DATETRUNC('month',TODAY())

       

      But I 've notived that this nolonger works in V6. I always get invalid Syntax.