Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

calculation of Quality Percentage


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