Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Question on Replace Function

Hi,   I add a new column by copying an existing one and changing the format from numbers to text (copied year column and division new one) then add my text as shown so that i can create a relations...
Need Help
  • shafiz_p's avatar
    shafiz_p
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

Thanks. Is it possible to do the following

 

1. concatenate Division with Invoice amount (Relationship 01)

1. concatenate Invoice Date  with comments (Relationship 02)

shafiz_p's avatar
shafiz_p
Super User
2 years ago

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!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    this is great...how can i add comma to distinguish between the 2 data

    • shafiz_p's avatar
      shafiz_p
      Super User
      2 years ago

      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!!