Skip to main content
Question

Business Reporter - Total multiple sections

  • October 11, 2023
  • 3 replies
  • 66 views

Forum|alt.badge.img+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

SandT
Hero (Partner)
Forum|alt.badge.img+6
  • Hero (Partner)
  • 31 replies
  • October 11, 2023

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.

 


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • 5 replies
  • October 11, 2023

we tried this

 

but got this as a result. 

Any idea what we did wrong?  


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Partner)
  • 5 replies
  • October 11, 2023

in More testing we fixed it.  thanks