7 Replies Latest reply on Oct 5, 2016 6:34 PM by keywords

    getsummary / getsummary =?

    KrisYells

      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