2 Replies Latest reply on Nov 24, 2018 5:14 PM by Paul Wachtler

    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