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 :)
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…
