Creating Calculated Column based on Account # in Smartlist Builder

(0) Share

Report

Posted on by Trevor Carter

Hello -

I am fairly new to using smartlist builder and am hoping someone can help me. I currently work with 2 different manufacturing brands and would like to create a calculated column that shows which brand it is based on GP Account #. So far I have had success using the CASE formula for other columns but it seems to not work with Account number. Account number is formatted XXXXX-XX.

Any help would be appreciated. Thanks

Categories:

Microsoft Dynamics GP