1 Reply Latest reply on Jul 30, 2014 8:07 AM by philmodjunk

    Sorting Data in 6 Fields (Columns)



      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.