0 Replies Latest reply: Apr 19, 2010 10:08 PM by Amirali Vastani RSS

    Straight Table - Expression Total

    Amirali Vastani

      Is it possible to use Expression Total for one expression, Sum of Rows for the Total for a second expression and then use Sum of Rows total/ Expression total in a third expression?

      For instance

      Sum(Sales) - Expression 1 has expression total

      Sum(Cost) - Expression 2 has expression total

      FABS(Sum(Sales) - Sum(Cost)) has Sum of rows total

      FABS(Sum(Sales) - Sum(Cost))/Sum(Sales) ===> I want to do this but QV computes an incorrect total using Expression Total for everything.