Link to home
Start Free TrialLog in
Avatar of Tammi Rush
Tammi Rush

asked on

Need to set a parameter inside a crystal report formula

I have a parameter in a crystal report for the end user to enter a number.  I want to pass this parameter to a formula that will be

if parameter > 0 then (parameter# * 35) + other field
else other field

I cannot figure out how to pass the parameter into the formula.
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tammi Rush
Tammi Rush

ASKER

First it said I needed a string for the 0 so I put it in "".  

If {?Skids} > "0" then
{?Skids} * 35 + {SHIPMENT_BOL.WEIGHT}
else {SHIPMENT_BOL.WEIGHT}

then it tells me a number or currency is require at the parameter after the then
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
DUH!  It's those little things that will get you every time.