2 Replies Latest reply on Nov 30, 2011 9:20 AM by catinthehat

    sort portal based on Calculations

    catinthehat

      Title

      sort portal based on Calculations

      Post

      i followed the advice in this post (http://forums.filemaker.com/posts/0f82f56e53) and it has been very helpful. i am still struggling with a related issue. I have set my portal to sort based on a text calc:

       

      Upper(
      Filter ( Left ( Type ; 1) ;
            
                   "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" ))

      For some reason it is not sorting it is showing me the following (attached screenshot) the red letters toward the left are the calc and the portal is set to sort based on them.

       

      any ideas are welcome, thanks

      Screen_shot_2011-11-30_at_12.01.05_PM.png