AnsweredAssumed Answered

Sorting Data in 6 Fields (Columns)

Question asked by Lawrencex on Jul 30, 2014
Latest reply on Jul 30, 2014 by philmodjunk


Sorting Data in 6 Fields (Columns)



     Could FM Pro experts please help me with the following:

     I have Fields (Columns) A, B,C,D,E,F with data.  I have to sort these datas into Fields (Columns) M,N,O,P,Q,R in

     ascending order in a Row.

     eg Fields: A=200,  B=300,  C=400,  D=100,   E= 600   F=500

     I have to obtain the following results in Fields M,N,O,P,Q,R in ascending Order

     by Row:

     ie. M=100,   N=200,   O=300   P=400,  Q=500   R=600.


     How do I set the calculation formulae in Fields:M,N,O,P,Q,R?

     Many thanks in advance.