Validation Code - Table Percentage

Dear Community,

I created the table with constraint percentage cannot more 100% for total category, but i cannot make it should be 100% for total

aUGydBfHRvZweXjG4QFMFZ.xlsx (6.9 KB)

I attached the xlsform, is there any more simple code to solve it.

Thanks in advance.

Best,
Budi

Maybe this post discussed previously should help you solve your issue:

Hi @Kal_Lam

Thanks for advice, Yes I tried to your approach function but same with my previous code. Its works when more than 100% constrainst message show up, but below 100% constraint message didn’t show up.

the code still allow input under 100%.

A=B+C+D+E+F=100%

Best,
Budi

Maybe you will need to put a check at end to see if the total has reached 100%. And flag this out if it has not reached. Should should solve your issue.

Hi @Kal_Lam

thanks so much for your advice and support. Yes, I put in the tabel to show the total then validate if not reach 100%.

Table 33.xlsx (6.9 KB)

I just upload, if any other community search for it, if in the next something nice solution :slight_smile:

Best,
Budi

1 Like

Thank you for sharing it with the entire community and making this a learning and sharing platform @bwijoyo! Expecting the same in the upcoming days too.