Solved

filemaker price calculator

Posted on 2007-11-24
6
770 Views
Last Modified: 2012-06-27
i need to make price calculator.
let's say if you buy christies $10,000 art piece, i want to calculate how much percentage of tax and final price we need to pay.
i want to set different country of auction site and user can set their tax and final price.
how much can i pull the data, tax and commission fee of auction site?
0
Comment
Question by:Tony T
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 20345300
can you re-phrase that?
"how much can i pull the data, tax and commission fee of auction site?" is too ambiguous to me?
do native english speaking experts (which I'm not) understand better?
0
 

Author Comment

by:Tony T
ID: 20345625
thank you, lesouef.
i think it's too ambiguous.
let me break it down.
i need to make two table.
one table, user can input final price or auction price.
the other, user can input tax percentage and commission fee.
my question is, how do i set tax percentage or comission fee?
because it depends on the auction final price and i need to set percentage range manually.
let's say auction site, final price is $100, $1000, $10000... all different.
i don't know how to set multiple percentage range which user can add.
0
 
LVL 28

Accepted Solution

by:
lesouef earned 125 total points
ID: 20345740
I did that once under fm6 back in 2002 I think...
if the price range is not the same for all auctions, you can't put it in a calc field.
The method I used was to create a commisison_fee table where the % is a multivalued field, say 10 values, and the price field, 11 values.
the calculation was comparing the ref price with the multivalued field to find out which price repetition number should be used.
See this examle quickly extracted from a fm6 file (this is why there are 2 files for 2 tables), but the principle is the same.
https://filedb.experts-exchange.com/incoming/ee-stuff/5801-price_range.zip
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Expert Comment

by:BadLT
ID: 20354655
how's this solution going... I think lesouf is 100% correct.... i see that being the easiest way to accomplish your needs.

B
0
 
LVL 28

Expert Comment

by:lesouef
ID: 20356240
this solution can be improved with a more complex calc made on each range to avoid the non monotonic response of the resulting price curve of such a mechanism. is some situations having a price for 99 items higher than for 100 is not accepted. the goal here was to show how to get a formula for qty ranges.
0
 

Author Closing Comment

by:Tony T
ID: 31410831
thank you
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question