String binding

KubotaNatsuki

hi!

 

I want to concatenate the strings!

When displaying the time, I want to use "hour" + ":" + "minute"!

Example: "9" + ":" + "15" → 9:15

I'm not good at English, so this may be difficult for you to understand.

Thank you!

Vinay VaradarajM

Hi @KubotaNatsuki ,

 

You can achieve this by using & in your expression instead of +, provided all are in text format.

If you have hour and minute in number format, you need to convert it to text by using text function.

 

Therefore, your overall formula should be text(hour)&" : "&text(minute).

However, it is recommended that you maintain the delimiter in an admin module lineitem, and refer it in your expression. This way you can main consistency, and the performance is not hampered.

 

Regards,

vinayvm

 

 

 

Jitendra.Vishnolia

Hey @KubotaNatsuki ,

 

Pls go through Operators and constants - Anaplan Technical Documentation this will be helpful for you to have better understanding of how to combine, compare, and perform mathematical or logical operations with your data.

 

~ Jitendra

KubotaNatsuki

Thanks for your reply!
I was able to create the module I wanted!
Thank you so much!

KubotaNatsuki

Thanks for your reply!
Thanks for pointing me to that page!
I'm learning so much!