I found errors on [BAGS AND CANS SIZE] and [Size Calc]
Primary "OUNCES" does not exist, only "OUNCE"
I modified other several tiny things and don't know what is essential.
You can compare "original" and "-SM"
[BAGS AND CANS SIZE]
RIGHT([Base Size],6) = "OUNCES")
RIGHT([Base Size],5) = "OUNCE")
one more thing, attaching packaged workbook is really helpful, but if the sample file is smaller like less than 2MB,
it's easier to try for more people.
SIZE TEST FILE_SM_9.0.twbx 12.7 MB
2 of 2 people found this helpful
Ok, thank you Shin.
I will give these changes a try on my end. Yes, sorry for the large file, I will supply a smaller one next time.
Again, thank you for your help. I really appreciate it.