here is my code that I had made
SUM(MAX(fieldname2, fieldname3, fieldname4, fieldname5, fieldname6, fieldname7, fieldname8), MIN(fieldname2, fieldname3, fieldname4, fieldname5, fieldname6, fieldname7, fieldname8) /2, MIN(fieldname2, fieldname3, fieldname4, fieldname5, fieldname6, fieldname7, fieldname8) /2 )
but it still don’t worked right as when one checkbox is clicked then the sum not working correnct. any idea how to fix the code then to achieve my objective discount rule?