Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# filemaker price calculator

Posted on 2007-11-24
Medium Priority
775 Views
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
Question by:Hiroyuki Tamura
• 3
• 2

LVL 28

Expert Comment

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

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

lesouef earned 500 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

LVL 2

Expert Comment

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

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

ID: 31410831
thank you
0

## Featured Post

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â€¦
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" Anâ€¦
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produâ€¦
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. â€¦
###### Suggested Courses
Course of the Month10 days, 10 hours left to enroll

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

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