1 Reply Latest reply on Jun 17, 2016 11:22 AM by Patrick A Van Der Hyde

    Adjusting a Calculation for YTD

    Cody Huth

      Hello all,

       

      I have the below calculation currently in a tableau dashboard I am using.  I want to be able to pull YTD totals, however I now need to adjust this to play well with multiple years.

       

      If [Metric] = 'YTD' then (if [Date]<= [Month] then [Converted Balances] else null end)

      elseif [Metric] = 'MTD' then ( if [Date] = [Month] then [Converted Balances] else Null end)

      end

       

       

      So for Metric = YTD i need to take Date > 01/01/2016 and less than or equal to Month...and pull those balances....

      The MTD part would stay the same.  How do i add the logic for Date > 01/01/2016????