CODEWITHSUNDEEP
excelpowerquery
PMNIServ1
PMNIServ1

Reputation: 59

Expression.Error: We cannot apply operator & to types Number and Number

I don't understand the root of this Type issue. I have added a custom column to combine two numbers. They are both Type123. I am unsure why the error pops up.

Number Data

Custom Colum

enter image description here

Upvotes: 2

Views: 23722

Answers (1)

Project Insights
Project Insights

Reputation: 108

Write the following expression in a custom column:

=Number.ToText([Patient Chart Number])&"."&Number.ToText([Visit Number])

Upvotes: 3

Related Questions