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?