1 Reply Latest reply on May 11, 2013 6:22 AM by Shawn Wallwork

    How to calculator sub total?

    Alice Zhang

      Hi All,

      How to calculate sub average on Col 1 for item P1 and P2?

      We need to calculate: Ave_Amt_P1 = Sum($20+$50+$30 in Col 4) / sum( 30+10+5 in Col 2) for item P1

      Then, we need to find out the value in Avg_Amt who is twice up than value in Avg_Amt_P1.

       

      Thanks in advance!

      sa.jpg