AnsweredAssumed Answered

Custom Reports - Earthwork Report

Question asked by Patrick L'heureux on Nov 26, 2018
Latest reply on Nov 28, 2018 by Patrick L'heureux

I am trying to create a custom earthwork report that shows  earthwork quantities for bounded areas but then gives the total at the bottom of the breakdown. 

 

The image below shows the breakdown but not the summation of the fills (it is just pulling the first fill value). I know in SQL I could accomplish this with a sum function but it appears that Word does not have the power to do that(I could be missing something). Could we get total cut and total fill added to the the list of values? 

 

Also, is there a way to get the surface names not to repeat? They are repeating because they are referenced twice (for each boundary) but I do not need them to be. 

 

 

Outcomes