Whenever something looks insanely complicated to me, I step back and see if there's an easier way to accomplish my crazy idea. And, usually there is.
In FileMaker we have tables. If you can add another table that contains your quantity breakdown, you can make your life a lot easier.
You should have 3 fields in your new table (aside from the primary and foreign keys):
then you can connect your new table to your job records by job-type and quantity and get your price that way.
Looks like you can have a million variants roughly, and you'll grow long grey hair before you simplify your calculation.
Which, by the way, could start with this:
Use the Let function to define your variables (the things you are calculating based on):
job_type = (job_type field from your DB);
quantity = (quantity field from your DB)
job-type is "business cards" and quantity is 250 ;
job-type is "business cards" and quantity is 500
Hope this helps.
Agnes B. Riley
FileMaker 10 and 11 Certified Developer
ZeroBlue Technology Solutions
where your data goes to work
Member, FileMaker Business Alliance
Member, FileMaker Technical Network
FileMaker Advanced 11.3 on Mac OS X 10.6.8
"Imagination is more important than knowledge..."
Stepping back is great advice! Speaking of which I'm about to head out for the day. Thanks for the quick reply. I will look further at your solution tomorrow.