13 Replies Latest reply on Nov 15, 2018 3:23 PM by Paul Wachtler

    Capturing subtotal as a field for use in later calculations

    Sam Johnson

      How can I capture the subtotal of a column that I can then use in a calculation? For example in the picture below I have the Curr Yr Amt. The MM column in this diagram is fixed at 5. But suppose they were all different. I now want to divide the MM by the total of the Curr Yr Amt column. Any help is appreciated.

      Thanks