0 Replies Latest reply on Oct 28, 2018 5:52 PM by Alex Martino

    How to return the max value in the first column

    Alex Martino

      Hello. I turned values into a dimension. And then I can quantity by unique values.

       

      How can I create a formula that returns the max value (in this case -3.59) based on quantity?

       

      What I want to do is to subtract the difference between the max and all the others so and multiply by quantity to see the dollar differential. Screen Shot 2018-10-28 at 5.47.04 PM.png