1 of 1 people found this helpful
I think you can handle this by adding a NULL test to each one, something like...
IFNULL([Division],'') + IFNULL([Sub-Division],'') + IFNULL([Product],'') + IFNULL([Sub-Product],'')
Let me know if that doesn't do the trick
Thank you for the super quick reply. That did work.