I am using CR XI R2.
I have four parameters necessary to run the report:
Formula,
Container (ie., box, bag, pail, etc),
Date (to run production),
Weight (to be produced)
In addition to the data entered in the parameters, I have the following database fields on the report:
Component (ingredients of part number selected in Formula parameter)
,
QtyPerLb (of each
Component listed in Details section.
I am designing a report in which I need to multiply
QtyPerLb by the number entered in the
Weight parameter in order to get a total weight per component. When I try to write a formula to accomplish this, I get an error:
"A number or currency amount is required here."
and it highlights the
Weight parameter:
{Structure.QtyPerLb} * {?Weight}
How can I write the formula correctly to accomplish my calculations?