Anaplan "Concat" & "Nested IF" Best practices

Options
Yashabh
Yashabh Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi Anaplaners,

 

I have a module with 5 Line Items, all formatted as text.

I have to concatenate the first 4 and give the output in 5th. However , out of the first 4 only the ones which have a specific value will be concatenated. (Eg. if 1st is "ABC" only then it will be a part of concatenation else not.) So there can be 16 possible outputs.

 

What i can think of is creating 4 boolean formatted line items and using If. 

Considering that both Concatenation & Nested If's are against Anaplan best practices, any suggestions would be appreciated.

 

 

 

Regards,

Yashabh 

 

 

Tagged:

Categories