Skip to Content
0
Former Member
Sep 11, 2008 at 08:24 PM

Sorting on a Formula field

13 Views

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}