AnsweredAssumed Answered

List Function Related Fields

Question asked by osninc on Aug 28, 2017
Latest reply on Aug 28, 2017 by osninc

I am trying to use the "List" function in a calculation to concatenate two fields F1 & F2 but want the result to be displayed without carriage returns and in an order that as F1=v1.

F1      F2

A .      100

B .      200

C .      300

 

When I do a List(F1, F2) I get the following:

A

B

C

100

200

300

 

What I want is this in a horizontal format with no carriage returns and be able to include the "=" and "," as is formatted below:

A=100,B=200,C=300

 

How can this be done with the List function in a calculation?

 

Thanks,

 

Tom

Outcomes