|
New asking questions but I've been using the forum for a while. Finally ran into an issue I can't seem to find help for so any assistance is greatly appreciated.
I have a report that shows several numbers. They are as followed:
Overall Total of Employees (count) Total of members (formula) Percentage of members (formula) Overall total of paying (formula) Percentage of paying (formula)
Everything seem to be working correctly except my last group of numbers. My formula is set as :
RoundUp((Sum ({@is_paying}, {tblshops.Name})/Count ({tblEmployee.id}, {tblshops.Name})*100))
This is giving me a percentage based on my overall total when I only want it to give me a percentage based on total of members. Please help!!
|