Sum multiple selection members cumulative and calculate percentage depending on issue date


#1

Hey guys,

i have one problem. I would like to sum multiple selection members cumulative and calculate the percentage of it depending on following measures(if issue with approval date is empty or overdue then set the value to 1 and if Review date is empty or overdue then set it 0,5 otherwise 0). Do it for all issues and calculate them cumulative and devide it with all issues to get percentage(already know how to do this).

Status for example: Open, Rework, Closed
Location for example: Berlin, Munich, etc.

I am very frustrating at the moment…I get wrong results all the time. They are close but not correct.
It would be great if you can help me. Thank you so much.