4 Replies Latest reply: Sep 21, 2010 2:36 PM by robrobin RSS

    Using a variable as a pivot table expression

      I have a variable [vTruckCnt] set to equal the expression [SUM(UNUnitRecCnt)/7]. Please see the image below. When my chart expression is set to equal the variable [vTruckCnt], it returns the wrong numbers and basically sums the two individual numbers to give me 352.14

      If I change the chart expression to the same expression [vTruckCnt] is set to equal, namely [SUM(UNUnitRecCnt)/7], it returns the proper values, those being 174.57 and 177.57

      Any idea why this does not work? I want to be able to use the variable as the expression because I use it, and other expressions, many many times.

       

      Thank you!

       

      error loading image