How we can concatenate two number line items?

Highlighted
Contributor

How we can concatenate two number line items?

I have got two number line items as shown below.

LineItem1 , LineItem2 , Result

     1                  2            1(2)

     3                  4             3(4)

     7                  10           7(10)

 

I want to get the result as shown above for the two line items.

Ideally i need a concatinated value.

Could you please assist me in achieving the same in Anaplan.

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: How we can concatenate two number line items?

HI Annes,

 

You can do the concatenation to numbered line items by putting text(). Change the resulting line item to text format and apply the below formula as per your need.

Concatenate.PNG

 Hope this would be helpful.

 

Thanks and Regards, 

Kavin

Regards,
Kavin.
Community Boss

Re: How we can concatenate two number line items?

Hi,

 

you can do:

text(line item 1) & "(" & text(line item 2) & ")"


Nathan Rudman, Anaplan Model Builder