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

    getsummary / getsummary =?



      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?



      10 records

      5 open

      5 closed