Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sorting on a Formula field

Everytime I try to do a sort on the formula field below, I can't sort on the field. It doesn't even show the field in the explorer window to sort on. The formula is below.

Sum ({fct_CurrentSales.Cases}, {@upc}) /

(tonumber(Maximum ({vw_dim_Product.CA_MPN_JMelBoxesPerPallet}, {@upc}))) / {Command.Previous Fiscal Month}

replied

Sorting is done at record level and you're using a sum in your formula as well as a maximum value. Not sure about what is being done in the {@upc} formula but it may be affecting it as well.

Look at your user guide and look up the multiple passes CR makes and what is done in each pass.

(I used to keep a copy of the multiple pass flowchart on the wall above my computer as it contains good information on what can be done and when during the report generation.)

Sum ({fct_CurrentSales.Cases}, {@upc}) /

(tonumber(Maximum ({vw_dim_Product.CA_MPN_JMelBoxesPerPallet}, {@upc}))) / {Command.Previous Fiscal Month}

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question