7 Replies Latest reply on Oct 4, 2018 8:12 AM by sabari.shrestha.0

    How to return the total Count before the highest number.

    sabari.shrestha.0

      Hi, I am trying to count the number of times (row) a person made the donation before they made their highest yet in a year. The last column shows what is the highest amount that person donated in a year so far and the 3rd column shows the donation made by that person so far.

      So as an example, if that person has donated $720 as his highest donation yet in a year so far, I want to return the number (count) of donation he made before he made that ($720) donation. In this case, I want to return 3. Thank you.

      Capture.PNG