Help

Roundup Summary from Pivot Block

Topic Labels: Extensions
1118 0
cancel
Showing results for 
Search instead for 
Did you mean: 
brett_parker
4 - Data Explorer
4 - Data Explorer

In Excel, I can insert a pivot table from a table in excel and add a formula field that “roundup” the sum from the pivot table. Can this be done using the Pivot table block?

For example: I have 4 unique records with a Sum of items from another table
Peter 4.14
Mary 3.2
Paul 7.3
Matthew 5.4

I want the above numbers to be rounded up to the next nearest number, 5, 4, 8 and 6.

Clearly my table has many records, hence the reason to automate if possible.

0 Replies 0