I am trying to concat country and team to show as Country-Team in the Teams Text Line item as shown below. Since there are formulae in place, country and team cannot be changes to text format. How can it be concatenated in the way I am looking for?
Hi,
I can see the Country and Teams line item is List formatted, so you can use the Name() Function to convert into text for concatenation in Teams Text line item you can use name(Country)&"-"&name(Teams) which will resolve your issue and give the concatenation in Text formatted. Hope it will help you!
Bhumit Jain
Thanks Bhumit, worked!
Only thing, I had to lookup the country display name from the country list as country was a numbered list :)
I want to do a SUM from the source module which has native users, SKU list and time dimension to a target module line item by all users by SKUs. Target module only has a subset of the SKU list and nothing else. Need some inputs on how to build the mapping for the SUM. Is it also possible with the Anaplan native users list…
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
