3 Replies Latest reply on Oct 31, 2018 12:56 PM by Anne Thibault

    Parameter vs. Calculated Field

    Anne Thibault

      I have 2 worksheets in my workbook - both working off the same data source - one worksheet uses date parameters (start date, end date and calculated field of "[Pick Up Date] >= [Choose a Start Date] AND [Pick Up Date] <= [Choose an End Date]" - the other worksheet is a year over year graph, so I did not want a start date, but want to anchor the end date at today, so I used a calculated field of "[Pick Up Date] <= TODAY()".

      Can anyone tell me why, when I compare the current month, the results are different between the 2?

      *When I remove the calculated field "[Pick Up Date] <= TODAY()" from the year over year graph, the data for the current month matches.

           Using version 10-5