sort portal based on Calculations
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:
Filter ( Left ( Type ; 1) ;
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