You should use Forcast (field or the expression which calculate it) in the sort order of the fields in your cycle group.
To do this go to the tab Groups in your Document properties (settings) Select your cycle group en click the Edit button.
Now select one field and the click Sort Order button. In the next screen you can select Expression and fill in any expression you want for any field you want.
Hope this is what you are looking for.