Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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