7 Replies Latest reply on May 7, 2018 12:27 AM by David Maning

    Use max function in Date logic

    Aman Singh

      Hi Team,

       

      Here i came with a problems which seems to look easy but i did not track this logic.

       

      My requirement would complete with below steps

      1. Find the sales on max date

      2. Find sales on max date -1 

      3. Subtract step 1 - step 2

      3. if day of date =1 then step 1 else step 3.

       

      You can use sample super store data for this.

       

      Regards,

      Aman