Hi Christian - Am not sure if I understood you properly. Because, if you need divide Not Completed by Attended, how can you get 0%, 15% and 15% respectively for % Not Completed. You should be getting 0% , 50% and 75%. Am i missing something here.
In the example given, I only want to divide by 100 (which is the first value under Attended). The other "attended" values (10 and 20) are not relevant for the purpose of the calculation.
So when you divide the Not Completed values by 100 you get 0%, 5% and 15%.
The trick here is that the value '100' needs to be dynamic I.e if I change the date filter this number will change as will the Not Completed values.
Hope that makes more sense, if not let me know.