nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CONCATENATE Formula in anaplan

UMAMAHESH

Hi experts,

How to write "concatenate formula" in anaplan.

We have 3 proprties in Customer list. I want to concatenate first and second properties into 3rd property.

The format of the properties is "Text".

Can you please suggest me.

Regards,

Uma

Accepted answers

LipChean_Soh

Hi,

Assuming all 3 properties are Text format, then

Properties 3 = 'Properties 1' & 'Properties 2'

If Properties 1 and/or Properties 2 are of List format, then you can use NAME() or CODE().

In alignment with the S(ystem) of DISCO, this should be in a List Properties MODULE, not in the LIST properties.

Thanks,

LipChean

All comments

LipChean_Soh

Hi,

Assuming all 3 properties are Text format, then

Properties 3 = 'Properties 1' & 'Properties 2'

If Properties 1 and/or Properties 2 are of List format, then you can use NAME() or CODE().

In alignment with the S(ystem) of DISCO, this should be in a List Properties MODULE, not in the LIST properties.

Thanks,

LipChean

AWhitworth

You can just use & after every text item and this will concatenate. Here is a link to the Anapedia page.

DavidSmith

@UMAMAHESH @AWhitworth

please refer to this article for guidance on how to use concatenation in the most efficient way

https://community.anaplan.com/t5/Knowledge/Formula-Optimization-in-Anaplan/ta-p/41663

David

sanyauklon

I live in Colombia and the weather changes a lot here. So I have to look at the weather forecast every day to get dressed properly. It's good that I found this https://tiempo.info/colombia site because it always has the most accurate weather forecasts in Colombia. I'm glad I found it because now I always know what weather to expect. I advise you to use it too if you don't know where to look for accurate weather forecasts

Quick Links

Can you help?

Unanswered questions

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
Looking for Anaplan End-Users to take a short survey!
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.…