Case Formula not working
Case([Commodity],"Commodity1",([Pallet Count]*[Price per Unit]),"Commodity2",([Pallet Count]*[Price per Unit]),([Case Count]*[Price per Unit]))
Basically I have a table to table relationship set up where "Commodity" and "Price" is pulled from the child table to the master table. So, once the commodity is selected it fills in the price. To make sure that the total does not change if the price is changed in the future, I set up a snapshot field of the "Price" lookup field named "Price per Unit".
For all commodities except for 2, the total is determined by "Case Count" * "Price per Unit". For the other 2 commodities the price is "Pallet Count" * "Price per Unit".
For some reason it is not recognizing the 2 commodity names and is only determining the total using "Case Count" * "Price per Unit" no matter what commodity is selected. I have this same formula used in other tables and it is working fine.....not sure what I am doing wrong in this one.
If someone has any suggestions I would appreciate it.....need this to work ASAP.
------------------------------
Jeannette Jeannette
------------------------------