I want to create a variable that brings the Vendor's IDs starting with 5 in BO 4.1 SP4.
So I have used below formula but It returns NULL.
=[Vendor] Where ([Vendor].[Key] = "5%")
My data source is from BEX.
How can I get my above mentioned result?