Have you clicked inside the field with the ? to see what is actually there? Sometimes the ? only indicates that there is too much data to display, but when you click inside the field it will open up to reveal the actual contents. For example, your first line 705 / 1361 = 0.5180014, multiplied by 100 to display as percentage = 51.80014. Perhaps you field is too narrow to display 7 numbers plus a decimal point. I would check that before worrying about any other possible cause.
My money is on Keyword's suggestion, but if it's really a ? due to a calculation error then I would look at:
GetSummary ( Summary TotalCount ; Asset )
More closely. If the value returned by this is empty or zero, then using a + operator produces a valid result (some value + 0) where division produces a divide by zero error.
Do I feel silly. Everyone was correct. The size of the field was causing the "?".
Thanks for the help Phil and Keywords!
Everything is working great now except the grand total. The blue row are sorted by asset the grey row is sorted by spread. Below are the calculations to get the percent for each level of sort.
GetSummary ( Summary ClosedCount ; Asset ) / GetSummary ( Summary TotalCount ; Asset )
GetSummary ( Summary ClosedCount ; Spread ) / GetSummary ( Summary TotalCount ; Spread )
I'm at a loss on how to get the percent for the grand total row. I have tried both versions of the calculation with incorrect results. Can anyone help?
Figured it out.A new calculation gave me what I was needing. See calculation is below.
Summary ClosedCount / Summary TotalCount
Glad to see you've got there. It's worth remembering that a single Summary field can be used to deliver different results simply by placing it on a different sub-summary layout part. Similarly a GetSummary calc can pull from different Sorts. Just be mindful that these are time-heavy processes, so deploy them with care.