Hi,

I'm trying to build a summary report grouped by Asset. Currently I have a summary field of total, a summary field of open and a summary field of closed. I need to calculate the percent closed/total.

Below is my current calculation. if I change the "/" to a "+" I get results. with the "/" I get a "?" .

GetSummary ( Summary ClosedCount ; Asset ) / GetSummary ( Summary TotalCount ; Asset )

Anyone know why it works with addition and not division? and anyone know how to solve this error?

Example:

10 records

5 open

5 closed

50%

You should read free FileMaker Training Series

FileMaker Training Series | FileMaker