Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Name | Projectnumber | Unit | Unitvalue | Amount | Total in hours |
---|---|---|---|---|---|
David | 126456345612 | Hour | 1 | 12 | 12 |
Mark | 312413534634 | Day | 8 | 4 | 32 |
How can i Sum the Total in hours column?
Kind regards,
Marco
Hi,
Try like this
=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))
Hope this helps you.
Regards,
Jagan.
Hi,
Try like this
=Sum(Aggr(sum(Amount)*[UnitValue], Name, ProjectNumber, Unit))
Hope this helps you.
Regards,
Jagan.
Thanks alot for your help!