Hello guys,
I'm having trouble designing a cross-tab.
The summarized field is Distinctcount of number of students who have taken a certain mark (e.g. 3 students have the mark of 78, 5 with mark of 63...). And i need to show it as percentage of the total number of students in a grade level (e.g. 3 out of 30 =10%).
However i'm trying to show the percentage with 2 decimal numbers and i have chosen this numbering style from the Format field option but still i'm getting round numbers in the output (e.g. 13% instead of 13.25%)
And this is affecting my output as the round numbers are adding up to 97% instead of 100% (because of the missing fractions)
Any suggestions?
IP Logged
