Jump to content
Sign in to follow this  
andruolson

Product Pricing Calculations

Recommended Posts

Hello, this is what I’m trying to achieve…

We are a window cleaning company, basically what I’m trying to do is automatically generate what a customer’s cleaning price would be to clean all their windows based on if the house is a 1 level or a 2 level, depending on how many windows, depending on where they are located (to cover gas prices)..

I have created what I’m trying to do in excel, but I’m unable to get it to work in FileMaker (Different formula language)

What I want to do is start with a base price.. say $25.00… then, for each window add say $2.00 (if it’s a 1 level) or add $2.50 (if it’s a 2 level…

Then, depending on what city/zip they are located at, it would add some trip fee… so say, customer lives 30 miles away, then it would add another $8.00 or if they lived 60 miles away, it would add $35.00 ect…

I have an Excel sheet I can send you with the same information, can anyone help?

Share this post


Link to post
Share on other sites

I have an Excel sheet I can send you with the same information, can anyone help?

It sounds relatively straight forward. I'll take a crack at it.

Why don't you post the Excel file here? Or send it over. Whatever works for you.

Share this post


Link to post
Share on other sites

Ahm... I'd suggest actually looking up the prices into Number fields, instead of using unstored calculations.

Share this post


Link to post
Share on other sites

You mean like this.

It appears I've still not wrapped my head totally around lookups. One question--why wouldn't the quotes::base field (converted to number as you suggested) not auto enter when I had the original relationship

quotes::<some field> ---- X ---- rates::<some field> ?

Populating that field seems like it should be independent of customers.

Windows2.fp7.zip

Share this post


Link to post
Share on other sites

Here's something you can try.

Things that changed:

Rates are all global fields

The 'quotes' table has changed

The 'customers' table has changes

Hover over new fields 'windows level 1' and 'windows level 2' for a tooltip explanation.

I'm uploading a modified file. See if you understand what's going on. If not, I'd be happy to explain.

Windows - 20120810.zip

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.