i am trying to do an exact match, but is wrong, how can i change my formula, so that it will show
if membercode = "11", it will show "affiliated" instead of "VIP"?
Thank you so much.
Go to Solution.
Set up a relationship from the Membercode column of Table1 to the Membercode column of Table2 (No Membercodes should repeat in Table2) and write the following calculated column formula in Table1
Hope this helps.
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!