shorty Posted December 12, 2000 Share Posted December 12, 2000 I have 3 databases (Advertiser, Rate, Invoices). In the advertiser file I have a field called contract frequency. In the rate file I have a rate code field of 3DR with the possibility of 9 different rate amounts based on frequency and size of ad. I can't seem to get the correct rate to show up in the Invoices file when I call on the rate code. I thought it would be by using a if calculation, but I never get past the first result. Thanks to anybody that might help me get past the dingbat zone? Link to comment Share on other sites More sharing options...
Vaughan Posted December 12, 2000 Share Posted December 12, 2000 Step 1: Explain to yourself all of the logic behind generating the correct rate code. That is the algorithm. Step 2: Convert the algorithm into an FMP calculation. Step 1 is the hardest. And only you know how to do it. Link to comment Share on other sites More sharing options...
Newbies dononyx Posted January 6, 2001 Newbies Share Posted January 6, 2001 Try a Case Statement? if you have 9 possibles, do the logic for the 9. I did not 100% understand what you want but it sounds like a case statement. Link to comment Share on other sites More sharing options...
LiveOak Posted January 6, 2001 Share Posted January 6, 2001 Do we get to look at your calculation or do I have to get out my Ouiga Board? -bd Link to comment Share on other sites More sharing options...
shorty Posted January 7, 2001 Author Share Posted January 7, 2001 The If calculation is like this: If(Size<=32 and Advertiser File::Contract Frequency1=6,Rate File::Six wk Amount, If(Size>32.5 and Advertiser File::Contract Frequency1=6,Rate File::Six week Amount Over,If (Size<=32 and Advertiser Filer::Contract Frequency1=13, Rate File::Thirteen wk Amount,If (Size>32.5 and Advertiser File::Contract Frequency1=13,Rate File::Thirteen wk Amount Over, If (Size <=32 and Advertiser File::Contract Frequency1=26,Rate File::Twentysix wk Amount,If(Size>32.5 and Advertiser File::Contract Frequency1=26,Rate File::Twentysix wk amount over,If(Size<=32 and Advertiser File::Contract Frequency1=52,Rate File::Fiftytwo wk Amount,If(Size>32.5 and Advertiser File::Contract Frequency1=52,Rate File::Fiftytwo wk Amount Over, Rate File::Open Rate)))))))) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8533 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