Re: Rounding of 4 decimal places doesn't work correctly
I agree with removing the rounding if that's allowed. However, I know that some schools actually do roud, so for instance a test score of 89.6% would count as an A since it rounds up. Perhaps GPAs work similarly.
I suspect the problem IS the rounding, though. QlikView rounding (and anything dealing with non-integers) is subject to mathematical error due to its use of binary numbers internally. I wrote an extensive document on exactly what was going on a few years ago, but it seems to have disappeared. I also appear to have ONLY written it on the forum, as I appear to have no copy on my hard drive.
The workaround is to deal in integers only. So instead of storing a GPA, store a GPA*1000 or *1000000 or whatever you need in the actual data model so that you're only storing integers. Only convert back to a regular GPA for display. It may or may not be worth it for any specific case. I've never bothered with the workaround. I just accept that QlikView is going to get some mathematics wrong sometimes.