How can i calculate Class Total. will it be formulat or set analysis.
Solved! Go to Solution.
I think mm has to clarify if it is typo or expecting to be aggr based on School. Coz his school name has ABD (will it be ABC or ABC only) as his total is 55.
That seems like a typo... but it might be aggr on School and Subject I think
Sum(TOTAL <School, Subject> Grades)
Sum(Grades)/Sum(TOTAL <School, Subject> Grades)
in my case i forgot to mention. Class Total field don't exist. I have to determine class total by School name and based on that used the total.
What is the problem you are facing? Did you try Sunny's below expressions?
Sum(TOTAL <School> Grades)
Sum(Grades)/Sum(TOTAL <School> Grades)
sorry i did not have total field. I was just trying to explain where it was comming from. Your expression don't give me right results. I think we will have to use Aggr function to get this results.