5 Replies Latest reply on Apr 15, 2018 11:16 PM by Peter Fakan

    Formula for filtering data connection 10.5


      I need help with a formula that I want to use as a condition for filtering data in the data source.I have a parameter in my workbooks called "Date Selector",


      I previously had this formula : [Date] = [Date Selector] which would show me the values in my data as of that reporting period but I have other data I want to include for older data where it is the latest available. I cant just say filter by latest available as I want to be able to use the date selector for older periods if needed and so wouldn't want the latest in that case. Using desktop 10.5.


      This is what I am thinking but need help on syntax:


      IF [Date] = [Date Selector] OR ([Date] < [Date Selector] AND ([Is Latest],"TRUE")