KrisYells

getsummary / getsummary =?

Discussion created by KrisYells on Oct 5, 2016
Latest reply on Oct 5, 2016 by keywords

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%

image.jpg

Outcomes