Forum Discussion
Solved
How can get % using pre-calculated denominator
I have a member log by company and the total N per company is pre-calculated. Member Id Program Attended Company Total Employees (Denominator) Company 1 Yes 100 A 2 No 100 A 3 ...
Esong2023 , this are parameters, and you can select numeric range under Parameter , than you can provide any numeric value into it that can be your company denominator
And for the formula you mentioned Sum(attended member count)/Company Denominator. In this instead of Company Denominator you can select parameter value which is higlighted in below snip
Esong2023 , this are parameters, and you can select numeric range under Parameter , than you can provide any numeric value into it that can be your company denominator
And for the formula you mentioned Sum(attended member count)/Company Denominator. In this instead of Company Denominator you can select parameter value which is higlighted in below snip