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!!
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)
Anonymous Yes it is possible.
1. Division with invoice amount - [Division] & Number.ToText([Invoice amount])
2. Invoice Date with comments - Date.ToText([Invoice Date]) & [Comments]
Hope this answered you question. If, please mark it as a solution!!this is great...how can i add comma to distinguish between the 2 data
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!!