Skip to main content

Hi  I’m trying to get a total for multiple sections and getting an error.   Limit the range in the formula to a single section.     Is there a way I can total more than one section. 

here’s an example.   we are breaking benefits out to list some accounts by site but want a total for all benefits 

 

Hi @Sshirley ,

 

Are there any row level repeaters available for the benefit accounts in the report design? If so please use the excel summation function like  “=SUM(G10+G12) “ instead of using “=SUM(G10:G12)” range.

 


we tried this

 

but got this as a result. 

Any idea what we did wrong?  


in More testing we fixed it.  thanks

 


Reply