Question

Business Reporter - Total multiple sections

  • 11 October 2023
  • 3 replies
  • 35 views

Badge +2

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 

 


3 replies

Userlevel 3
Badge +6

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.

 

Badge +2

we tried this

 

but got this as a result. 

Any idea what we did wrong?  

Badge +2

in More testing we fixed it.  thanks

 

Reply