Mcottuli
asked on
Formula Help for Crystal Report
I need some assistance trying to come up with a formula in crystal. Attached is a picture that I think should give you what you need, along with the below txt.
Currently 5 (ItemDemand.ReOrdQTY) is the correct answer for "# of packages to Reorder to Max", although there are rare times when the answer needs to change. When 1 is greater than 4 then 5 should be replaced by 4-2+3 (Please see picture for table information)
tables.jpg
Currently 5 (ItemDemand.ReOrdQTY) is the correct answer for "# of packages to Reorder to Max", although there are rare times when the answer needs to change. When 1 is greater than 4 then 5 should be replaced by 4-2+3 (Please see picture for table information)
tables.jpg
ASKER
i tried that but the field are actually Sum of (field) in a couple cases. should it matter ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You need to replace the fields with your field names
If ({Field1} > {Field4}) then
{Field4} - {Field2} + {Field3}
Else
{Field5}
mlmcc