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


      AmountTotal in hours


      How can i Sum the Total in hours column?


      Kind regards,