PDA

View Full Version : Sorting totals or formulas



wstansbury
9-May-2013, 10:46 AM
I want to sort by Win Rate (pls see attached file) but when I go to List Oprtions it will not allow me to sort.

Eddy Kleinjan
10-May-2013, 02:53 AM
Although I'm not sure how 'Win Rate' has been defined, I assume that this is a calculated formula at the Dynamic AI level, not a SQL based formula. DAI based formula's are being calculated at the Dynamic AI side and are therefor not available for sorting as Dynamic AI relies on the database for sorting. If possible, you could try to rewrite the formula so that is available as a SQL formula.

Eddy Kleinjan


I want to sort by Win Rate (pls see attached file) but when I go to List Oprtions it will not allow me to sort.

Bob Cergol
10-May-2013, 07:40 AM
Wayne,

It looks like you have only 1 grouping + caption. Another solution you might consider making this a Top# report and then you can sort the total ascending or descending. Just set the value for "Show Top __ Values" to a number high enough to cover all the rows your report might contain, and then you can choose sorting.

Bob