Forum Discussion

JeannetteBagnol's avatar
JeannetteBagnol
Qrew Member
5 years ago

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...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Is the spelling correct for "Commodity1", maybe missing a space perhaps



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JeannetteBagnol's avatar
JeannetteBagnol
Qrew Member
5 years ago
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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    I 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
    ------------------------------