crystalhelp1
Technical User
I am trying to sort a group based on a formula...
(if isnull({@QOH}) then
0
else
{@QOH}) -
((if isnull(Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) then
0 else
Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) +
(if isnull({%3 Mo. Fcst.}) then
0 else
{%3 Mo. Fcst.}))
...the formula does not show up on the "Group Sort" drop down...any ideas how I can sort on this formula field?
(if isnull({@QOH}) then
0
else
{@QOH}) -
((if isnull(Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) then
0 else
Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) +
(if isnull({%3 Mo. Fcst.}) then
0 else
{%3 Mo. Fcst.}))
...the formula does not show up on the "Group Sort" drop down...any ideas how I can sort on this formula field?