0 Replies Latest reply: Feb 21, 2012 11:43 AM by jhoffef15 RSS

    Exporting MaxString( ) to excel

      Hello,

       

      I have a feild (Order Status) that's comprised of two letter status abbreviaitons. This is a "mixed feild" in that it is denoted by letters but has a numerical value as well. This is so we can filter and see those that are complete on the top , and those that are in the begining stages on the bottom ( or vise versa).

      I am using a maxString() function to find the highest (current) order status for each order. However, when I export to excel, the numerical value for the order status is exported , not the two letter abbreviation. I can convert to text in my expesssion but, that takes away the filtering capabiltties.

       

      Any thoughts?

       

      Thanks!