AnsweredAssumed Answered

Need help with a multi-variable Case Function

Question asked by krelsman on Jan 16, 2019
Latest reply on Jan 19, 2019 by comment

Hi, I have been away from FileMaker for a few years and am struggling to make sense of a recent attempt at using the case function in a new database. Below is an image of a page that I am using to try and organize a handed down family stamp album after the death of my father. I am trying to use a set of parameters found in a number of pull down windows and generate a dollar value using a table from another layout of fixed dollar values. Please see the image below:

 

Stamp Front.png

 

I am using the options from Type, Cancel, Front, Flaws, Back and Hinge. I have tried to brute force this as seen below but this has produced results where only some of the parameters selected work. By that I mean if I separate the cases where Type = "Mint" from the Type = "Used" I can get some of them to work but when combined as below only some of the "Mint" ones work.

 

If ( Album = "N"; "" ;

 

Case (

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "" and Back = "OG" and Hinge = ""; Scott NH Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "" and Back = "OG" and Hinge = ""; Scott NH Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "" and Back = "OG" and Hinge = ""; Scott NH Valuation;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "" and Back = "OG" and Hinge = ""; Scott NH Valuation*1.1;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "" and Back = "OG" and Hinge = ""; Scott NH Valuation*1.25;

 

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "" and Back = "OG" and Hinge = "LH"; Scott Valuation*.9;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "" and Back = "OG" and Hinge = "LH"; Scott Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "" and Back = "OG" and Hinge = "LH"; Scott Valuation;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "" and Back = "OG" and Hinge = "LH"; Scott Valuation*1.1;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "" and Back = "OG" and Hinge = "LH"; Scott Valuation*1.2;

 

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "" and Back = "OG" and Hinge = "H"; Scott Valuation*.9;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "" and Back = "OG" and Hinge = "H"; Scott Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "" and Back = "OG" and Hinge = "H"; Scott Valuation;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "" and Back = "OG" and Hinge = "H"; Scott Valuation*1.1;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "" and Back = "OG" and Hinge = "H"; Scott Valuation*1.15;

 

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "" and Back = "OG" and Hinge = "HR"; Scott Valuation*.9;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "" and Back = "OG" and Hinge = "HR"; Scott Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "" and Back = "OG" and Hinge = "HR"; Scott Valuation;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "" and Back = "OG" and Hinge = "HR"; Scott Valuation*1.1;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "" and Back = "OG" and Hinge = "HR"; Scott Valuation*1.15;

 

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*.9;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*1.05;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*1.1;

 

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*.9;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*.95;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*1.05;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "Crease" and Back = "OG" and Hinge = ""; Scott NH Valuation*1.1;

 

Type = "Mint" and Condition = "N/A" and Front = "VG" and Flaws = "" and Back = "DG<10%" and Hinge = ""; Scott NH Valuation*.75;

Type = "Mint" and Condition = "N/A" and Front = "F" and Flaws = "" and Back = "DG<10%" and Hinge = ""; Scott NH Valuation*.8;

Type = "Mint" and Condition = "N/A" and Front = "VF" and Flaws = "" and Back = "DG<10%" and Hinge = ""; Scott NH Valuation; .85;

Type = "Mint" and Condition = "N/A" and Front = "XF" and Flaws = "" and Back = "DG<10%" and Hinge = ""; Scott NH Valuation*.9;

Type = "Mint" and Condition = "N/A" and Front = "S" and Flaws = "" and Back = "DG<10%" and Hinge = ""; Scott NH Valuation*.95;

 

Type = "Used" and Condition = "VL-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.95;

Type = "Used" and Condition = "VL-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation;

Type = "Used" and Condition = "VL-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*1.05;

Type = "Used" and Condition = "VL-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*1.1;

 

Type = "Used" and Condition = "L-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.9;

Type = "Used" and Condition = "L-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.95;

Type = "Used" and Condition = "L-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation;

Type = "Used" and Condition = "L-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*1.05;

Type = "Used" and Condition = "L-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*1.1;

 

Type = "Used" and Condition = "C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.85;

Type = "Used" and Condition = "C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.9;

Type = "Used" and Condition = "C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.95;

Type = "Used" and Condition = "C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation;

Type = "Used" and Condition = "C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*1.05;

 

Type = "Used" and Condition = "H-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.75;

Type = "Used" and Condition = "H-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.85;

Type = "Used" and Condition = "H-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.9;

Type = "Used" and Condition = "H-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.95;

Type = "Used" and Condition = "H-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation;

 

Type = "Used" and Condition = "VH-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.75;

Type = "Used" and Condition = "VH-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.85;

Type = "Used" and Condition = "VH-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation;90;

Type = "Used" and Condition = "VH-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation*.95;

Type = "Used" and Condition = "VH-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = ""; Scott Used Valuation;

 

Type = "Used" and Condition = "VL-C" and Front = "VG" and Flaws = "" and Back = "DG.50%" and Hinge = "LH"; Scott Used Valuation*.9;

Type = "Used" and Condition = "VL-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.95;

Type = "Used" and Condition = "VL-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation;

Type = "Used" and Condition = "VL-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*1.05;

Type = "Used" and Condition = "VL-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*1.1;

 

Type = "Used" and Condition = "L-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.9;

Type = "Used" and Condition = "L-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.95;

Type = "Used" and Condition = "L-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation;

Type = "Used" and Condition = "L-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*1.05;

Type = "Used" and Condition = "L-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*1.1;

 

Type = "Used" and Condition = "C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.85;

Type = "Used" and Condition = "C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.9;

Type = "Used" and Condition = "C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.95;

Type = "Used" and Condition = "C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation;

Type = "Used" and Condition = "C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*1.05;

 

Type = "Used" and Condition = "H-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.75;

Type = "Used" and Condition = "H-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.85;

Type = "Used" and Condition = "H-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.9;

Type = "Used" and Condition = "H-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation*.95;

Type = "Used" and Condition = "H-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "LH"; Scott Used Valuation;

 

Type = "Used" and Condition = "VL-C" and Front = "VG" and Flaws = "" and Back = "DG.50%" and Hinge = "H"; Scott Used Valuation*.8;

Type = "Used" and Condition = "VL-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.85;

Type = "Used" and Condition = "VL-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.9;

Type = "Used" and Condition = "VL-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.95;

Type = "Used" and Condition = "VL-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation;

 

Type = "Used" and Condition = "L-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.8;

Type = "Used" and Condition = "L-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.85;

Type = "Used" and Condition = "L-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.9;

Type = "Used" and Condition = "L-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.95;

Type = "Used" and Condition = "L-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation;

 

Type = "Used" and Condition = "C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.85;

Type = "Used" and Condition = "C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.9;

Type = "Used" and Condition = "C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.95;

Type = "Used" and Condition = "C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation;

Type = "Used" and Condition = "C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*1.05;

 

Type = "Used" and Condition = "H-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.75;

Type = "Used" and Condition = "H-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.85;

Type = "Used" and Condition = "H-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.9;

Type = "Used" and Condition = "H-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation*.95;

Type = "Used" and Condition = "H-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "H"; Scott Used Valuation;

 

Type = "Used" and Condition = "VL-C" and Front = "VG" and Flaws = "" and Back = "DG.50%" and Hinge = "HR"; Scott Used Valuation*.9;

Type = "Used" and Condition = "VL-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.95;

Type = "Used" and Condition = "VL-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation;

Type = "Used" and Condition = "VL-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*1.05;

Type = "Used" and Condition = "VL-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*1.1;

 

Type = "Used" and Condition = "L-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.9;

Type = "Used" and Condition = "L-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.95;

Type = "Used" and Condition = "L-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation;

Type = "Used" and Condition = "L-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*1.05;

Type = "Used" and Condition = "L-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*1.1;

 

Type = "Used" and Condition = "C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.85;

Type = "Used" and Condition = "C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.9;

Type = "Used" and Condition = "C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation;.95;

Type = "Used" and Condition = "C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation;

Type = "Used" and Condition = "C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*1.05;

 

Type = "Used" and Condition = "H-C" and Front = "VG" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.75;

Type = "Used" and Condition = "H-C" and Front = "F" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.85;

Type = "Used" and Condition = "H-C" and Front = "VF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.9;

Type = "Used" and Condition = "H-C" and Front = "XF" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation*.95;

Type = "Used" and Condition = "H-C" and Front = "S" and Flaws = "" and Back = "DG>50%" and Hinge = "HR"; Scott Used Valuation;

 

Scott Valuation)

)

 

I am sure there is a better way perhaps by defining variables but not being a programmer and having been away from FileMaker for a few years don't really know where to start. Any help would be greatly appreciated or at least pointed in some direction so I can move forward.

 

Thanks in advance, Ken

Outcomes