2 Replies Latest reply on Oct 27, 2017 7:02 AM by Zhouyi Zhang

    Formula Help

    AJ.Yusuf

      Hi All

       

       

      I have this formula:

       

      INT(([Asking Price]>1) and ([Reporting Date]=[Reporting date]-1 and ISNULL([First Time In Main Pool]) and [Invoice Date]=[Reporting Date]

       

       

      Its supposed to see if when the reporting date is one day back [reporting date]-1 and Asking price is >1 and the [first time in main pool] is null and the invoice date matches the real reporting date not reporting date -1 just the reposting date

       

      I think I am going wrong with the reporting date-1 as it essentially needed to check if in the date before if there was a asking price of >1 and that the invoice date matches the current reporting