2 Replies Latest reply on Aug 2, 2018 10:16 PM by Ankit Bansal

    If numbers for yesterday are missing use numbers from a day before

    Anton Goncharuk

      Hey guys,

       

      We have three partners who report us their numbers on a daily basis through API, but one of the partners sometimes delays with their numbers (please see screenshot). I want to create a calculated field, so if numbers are missing for yesterday I want the numbers from a previous day (a day before yesterday) be on a worksheet for that partner for yesterday (to see a rough situation). Can please someone help me with it?

       

      Thank you,