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!
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
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
There was an error rendering this rich post.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
