Forum Discussion
Question on Replace Function
Anonymous Put comma inside a double quotation and use & like below:
Date.ToText([Invoice Date]) & " , " & [Comments]Hope this answered your question. If, please mark it as a solution!!
Hi,
Will the column add the text when new rows are introduced after refresh because I got conflicting answer?
I attempted to use Custom Column but I don't know how to do it. Can someone share me the syntax i need to use?
Anonymous Please find the image below to create custom column. If your column is integer data type, then you need to convert it to text first to add custom text, otherwise it will throw error.
Number.ToText() function helps to convert numbert to text and '&' is used as concat text.
If this solves your problem, mark it as solution.
Hi,
Your code is great. Is it possible to capture the Text without the year as shown?
//NT
Anonymous Based on my understanding, you’d like to concatenate the ‘Division’ column with the ‘Year’ column and change the data type to text.
To achieve this, simply replace the hardcoded value ‘IND’ with the actual column name ‘[Division]’ and update the data type accordingly.”
Feel free to ask if you need further clarification or assistance!
If this answered your question, please mark it as solution!!
Thanks. Is it possible to do the following
1. concatenate Division with Invoice amount (Relationship 01)
1. concatenate Invoice Date with comments (Relationship 02)