Product Pricing Calculations

August 9, 201213 yr

Newbies

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?

August 9, 201213 yr

Automatic message

This topic has been moved from "Community Resources → Articles, Tips, Techniques & Solutions" to "Brain Food → The Left Brain".

August 10, 201213 yr

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.

August 10, 201213 yr

Perhaps this will help:

Windows.fp7.zip

August 10, 201213 yr

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

August 10, 201213 yr

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