Jump to content

Help with Case or IF statement


This topic is 5678 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have a three different price structure depending on which level a customer is buying at and so have to choose between 3 different prices on a lot of products.

I can't seem to get the choice in there. I just get a zero.

I have been trying a few things but don't seem to be able to get the answers to come up.

Help.

Bruce

Link to comment
Share on other sites

Whenever scripts and calc's gets complicated, is it usually a syntom of a casual relational structure!

Especially with price matrix'es are Case( and If( nestings in my opinion the wrong choise. Such data needs to get stored in a separate table, where a calc'function like:

http://www.filemaker.com/help/FunctionsRef-315.html

...lets you define nice and easy what value to use further in the price-calc'.

It's BTW lightning fast compared to a nested statement, Filemaker have similarities with spreadsheets - with the use of calc'fields, but using filemaker as a spreadsheet is wrong!

--sd

Link to comment
Share on other sites

This topic is 5678 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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