S
Stephen Rapole
Guest
I am attempting to create a report in crystal which has a weight which varies based upon our WMS database. I have two separate tables I need to pull from where one has a yes/no for an item definition and this table also has weight for the items, and the other table has catch weights for items without defined weights.
I am attempting to have one formula either pull the weight for an item and multiply it by the cases per pallet or if the item has a catch weight (scanned weights individually per pallet), display the catch weight.
Where the weight for the item defintion is {WITEMUOM1.WEIGHT},
The quantity of cases per pallet is {WINVENTORY.QTYONHAND},
and the sum of case catch weights on the pallet is {#TOT PACK CW WEIGHT}
Below is an example of one of the formulas I have attempted to use and none net me a usable result.
The issue I am having is that it seems to be culling one half of the 'boolean' results; if I set the if statement for catch weights to = NO, the formula is culling all non-catch weight results and if I set it =YES, I get the same result, the if/then is not working and seems to just be reading only the else statement and only displaying it's results.
Basically, I want the formula to read:
({wInventory.QtyOnHand} * {wItemUOM1.Weight}) if catchweight = no, and
{#TOT PACK CW WEIGHT} if catchweight = yes.
For whatever reason I cannot figure out how to get this output both results regardless of how I phrase the formula and how much googling I do.
Help would be extremely appreciated! Thank you!
Continue reading...
I am attempting to have one formula either pull the weight for an item and multiply it by the cases per pallet or if the item has a catch weight (scanned weights individually per pallet), display the catch weight.
Where the weight for the item defintion is {WITEMUOM1.WEIGHT},
The quantity of cases per pallet is {WINVENTORY.QTYONHAND},
and the sum of case catch weights on the pallet is {#TOT PACK CW WEIGHT}
Below is an example of one of the formulas I have attempted to use and none net me a usable result.
The issue I am having is that it seems to be culling one half of the 'boolean' results; if I set the if statement for catch weights to = NO, the formula is culling all non-catch weight results and if I set it =YES, I get the same result, the if/then is not working and seems to just be reading only the else statement and only displaying it's results.
Code:
IF {WITEM.CATCHWEIGHT} = NO THEN ({WINVENTORY.QTYONHAND} * {WITEMUOM1.WEIGHT})
ELSE {#TOT PACK CW WEIGHT}
Basically, I want the formula to read:
({wInventory.QtyOnHand} * {wItemUOM1.Weight}) if catchweight = no, and
{#TOT PACK CW WEIGHT} if catchweight = yes.
For whatever reason I cannot figure out how to get this output both results regardless of how I phrase the formula and how much googling I do.
Help would be extremely appreciated! Thank you!
Continue reading...