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
Hi everyone, I'm trying to use this function on specific members of my grid, as described in the documentation. In my example, the grid contains two row elements: ACTIF and PASSIF. The problem is that when I use this function, it affects all elements in the grid, whereas I only want it to apply to the specified member:…
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
