Case Formula not working
I have a formula set up:
Case([Commodity],"Commodity1",([Pallet Count]*[Price per Unit]),"Commodity2",([Pallet Count]*[Price per Unit]),([Case Count]*[Price per Unit])) Basically I have a table...
Forum Discussion
It is actually fruit names and I thought of that so I went to the master table and copied them directly from there.
------------------------------
Jeannette Jeannette
------------------------------
------------------------------
Jeannette Jeannette
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI don't see anything wrong with your formula so it should be working.
But if you are desperate, you could rewrite the formula like this
IF(
Contains([Commodity], "apples", [Pallet Count]*[Price per Unit],
Contains([Commodity], "peaches", [Pallet Count]*[Price per Unit],
[Case Count]*[Price per Unit])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But if you are desperate, you could rewrite the formula like this
IF(
Contains([Commodity], "apples", [Pallet Count]*[Price per Unit],
Contains([Commodity], "peaches", [Pallet Count]*[Price per Unit],
[Case Count]*[Price per Unit])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------