AnsweredAssumed Answered

sort portal based on Calculations

Question asked by catinthehat on Nov 30, 2011
Latest reply on Nov 30, 2011 by 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

Outcomes