2 Replies Latest reply on Feb 8, 2016 6:01 PM by Shanaka Gunaratna

    How do I divide two grand total calculations?

    kris ma

      I have two columns: Sales, Units. I created a third field called [Dollars per Unit] with the calculation [Sales]/[Unit].The Dollars per Unit calculation for each row shows the correct value, however, I want to know the [Total Sales]/[Total Units] to get the overall [Dollars per Unit]. How do perform this calculation?