How to Calculate the accuracy Percentage

Hi ,

I am trying to calculate the percentage of accuracy based on the severity against the order.

the defect ratings are as follows:

No findings = 100%
Low findings only = 90%
No more than two moderate findings = 80%
Three or more moderate or at least one high finding = 60%

Could you please assist me how to achieve the desired output from the below table. Snap given below for your reference.

image

Hi @tdr_Dinesh
you could try something like

avg("some value",[severity])

BR

Hi @tdr_Dinesh
could you find a solution?
BR

Hi @ErikG,

We still haven’t found the solution.

Hi @tdr_Dinesh
is it possible to share some sample data or an Arena analysis?
BR

Hi @ErikG,

Sure, I apologize for the delayed response,

Thank you!

@tdr_Dinesh ,
Since we have not received a response from you on this question, we are going to archive the question. If you still need this question answered, please create a new question topic.