5 Replies Latest reply on Sep 25, 2018 11:35 PM by Haan Haan

    Formula for difference of min and max date of a period

    Haan Haan

      Hi all

      For example the period is "Month".

      What is the formula to get: Value for (max date of the month) minus Value for (min date of the month)

       

      Same goes to " Quarter" and " Year"

      Value for (max date of the quarter) minus Value for (min date of the quarter)

      Value for (max date of the year) minus Value for (min date of the year)

       

      Thank you.