You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!