Forum Discussion
UPC Check Digit Formula Needed
Hello -
My issue at hand is I currently have a UPC that I need to add a check digit too in order to enable the barcode scanner feature. From what I've seen it may be possible to create a formula to acheive this it just appears to be lengthy - I was looking for help on contructing this formula or if there is a solution that can enable the barcode scanner without this as well then I will be interested in either!
Thank you for the help!
3 Replies
Anonymous Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi Anonymous ，
There is this site to test out a few UPC's to see if it works as expected.
And depending on what your database back end looks like, here is an example of how to create a SQL function to return the check digit. You could append this to the existing 11 digit UPC in a new column for reporting purposes.
Wish it is helpful for you!
Best Regards
Lucien
Hi Anonymous ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
