I've been struggling with this for some time, so I'm hoping someone can help me. I'm using the calculation below for the current period and have another for comparison period. if I can get one to work so will the other.
Select a metric refers to countd(Car no) and avg(audit score). I am able to change the formula below by adding Countd(IF but the metrics are two different aggregations. I don't want users to loose the option to select. What can I do?