Newbies Novice Bruce Posted May 23, 2006 Newbies Share Posted May 23, 2006 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 More sharing options...
Lee Smith Posted May 23, 2006 Share Posted May 23, 2006 Paste your Calculation. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 23, 2006 Share Posted May 23, 2006 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 More sharing options...
Recommended Posts
This topic is 6549 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 accountSign in
Already have an account? Sign in here.
Sign In Now