AnsweredAssumed Answered

Formula for calculating Overall status

Question asked by Nipun R on May 19, 2014
Latest reply on Jun 11, 2014 by Nipun R

Hi Guys,

We are using clarity V 13.3 and Oracle. We have a requirement to add 4 lookup attributes (with weightage of 1 to 3 -quality,schedule etc) to a custom object and derive the overall status based on these 4 attributes values using below formula.

overall status= attribute1+attribute2+attribute3+attribute4/ Count of selected attributes .

I have created a formula for the calculation of Overall status but Iam not able able to get the count of selected attributes. Is there any way to get the attribute count..

Any kind of help is highly appreciated

Thanks

Nipun

Outcomes