2 Replies Latest reply: Jun 6, 2013 12:51 PM by Marco van der Have RSS

    SUM Column in text field

      Hi all,

       

      Short question, I'm trying to calculate the total of an expression. The expression is positioned in an pivot table. How can i create a SUM of the expession in a textfield outside the pivottable?

       

      Inside the table i use the following: =sum(Amount)*[UnitValue]

       

      The goal is to sum the total hours in the data show in the table in a text field next to the table. look at the example below

       

      NameProjectnumberUnitUnitvalue
      AmountTotal in hours
      David126456345612Hour11212
      Mark312413534634Day8432

       

      How can i Sum the Total in hours column?

       

      Kind regards,

       

      Marco