This is a continuation of this thread ( but since it is diifferent, I decided to start a new thread.
I have Crystal 8.5 with and oracle 10 database.
I Have a formula field I want to sort my report by. The problem is, it does not show up in my TOP N/Sort function.
The field I now want to sort by is this:
@new availability: (availability of machine)
if {@new mtbf calculation} <> 0 then
{@new mtbf calculation}/({@new mtbf calculation}+ {@average of repair time} )*100
else 0
@ new mtbf calculation: (Simplified Mean Time Between Failure Calculation)
if Sum ({@simple wo count}, {WORKORDER.EQNUM}) <> 0 then
{@date range calculation} /Sum ({@simple wo count}, {WORKORDER.EQNUM})
else 0
@average of repair time:
Sum ({@Repair Time}, {WORKORDER.EQNUM})/Count ({WORKORDER.WONUM}, {WORKORDER.EQNUM})
@simple wo count: (Could also use summary function)
if {WORKORDER.WONUM} = {WORKORDER.WONUM} then 1
@date range calculation: Calculates number of hours in Parameter selection
tonumber (DateDiff ("h", minimum({?Report Date}),maximum({?Report Date}) ))
I can see every other formula field in the Top N function except the “@date range calculation”, which leads me to believe that it may be the field that keeps me from seeing “@new availability” in the list. Is there any way to sort by my formula field?
I have Crystal 8.5 with and oracle 10 database.
I Have a formula field I want to sort my report by. The problem is, it does not show up in my TOP N/Sort function.
The field I now want to sort by is this:
@new availability: (availability of machine)
if {@new mtbf calculation} <> 0 then
{@new mtbf calculation}/({@new mtbf calculation}+ {@average of repair time} )*100
else 0
@ new mtbf calculation: (Simplified Mean Time Between Failure Calculation)
if Sum ({@simple wo count}, {WORKORDER.EQNUM}) <> 0 then
{@date range calculation} /Sum ({@simple wo count}, {WORKORDER.EQNUM})
else 0
@average of repair time:
Sum ({@Repair Time}, {WORKORDER.EQNUM})/Count ({WORKORDER.WONUM}, {WORKORDER.EQNUM})
@simple wo count: (Could also use summary function)
if {WORKORDER.WONUM} = {WORKORDER.WONUM} then 1
@date range calculation: Calculates number of hours in Parameter selection
tonumber (DateDiff ("h", minimum({?Report Date}),maximum({?Report Date}) ))
I can see every other formula field in the Top N function except the “@date range calculation”, which leads me to believe that it may be the field that keeps me from seeing “@new availability” in the list. Is there any way to sort by my formula field?
