Planning Calc Script - @COUNT with Condition
Summary:
Hello - not sure why I am struggling so much with this but we have a rule where we want to have an IF statement to only include shared member projects that meet a % criteria, then divide 1 by the count of shared projects that meet that % criteria. The problem is that the denominator of the calculation is not taking the % criteria into consideration, has anyone ever had this issue that they have had to solve for? Highlighted below is the % criteria and then the part of the calculation where we also need the % taken
Tagged:
0