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
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
