Expand my Community achievements bar.

calculation of Quality Percentage

Avatar

Level 1

I have created a custom form to calculate quality score.

 

there are e sections in this form one is which shows quality impact field, second field is Error fields and third field is where quality percentage will be calculated.

 

in the custom form i have 3 options Error, No error and NA

i wrote formula below formula is quality implact field 

SUM(IF({DE:Primary Template}!="NA","1"),
IF({DE:Template Name}!="NA","1"),  like this 19 steps since my cutome form has 19 fields
 
Under Error field i wrote below formula for 19 fields 
SUM(IF({DE:Primary Template}="Error"||{DE:Primary Template}="No Error","1"),
IF({DE:Template Name}="Error"||{DE:Template Name}="No Error","1"),
 
 
finally for quality percentage i wrote this formula
CONCAT(ROUND(DIV(SUB({DE:Quality Impact Fields Calc},{DE:Error fields calc}),{DE:Quality Impact Fields Calc}),2)*100,"%")
 
once the custome for is filled and all 19 points in form is fille wither with Error,No error or NA and i save the form i should see
 
Quality impact field : a number should be seen
Error field : number showing how many error fields i marked should be seen
 
Quality percentage : i should see the quality percentage.
 
 
but this is not happening , Am i missing anything in logic, plz can some one help.
0 Replies