topaznz Posted July 27, 2007 Share Posted July 27, 2007 I'm in the mist of completing a financial tracking system which talks directly with our default accounting system. I'm trying to create a caluclation within a table to do the following. If "GST status" = Yes, then divide "Amount" by 8 . The good thing about FM is I can ask small questions and apply them to many other situations I get myself into. I have just finished a automated client database for a treatment centre. I'd apprecitate any advice for the calculation I'm trying to achieve. Regards, Topaz Link to comment Share on other sites More sharing options...
bcooney Posted July 27, 2007 Share Posted July 27, 2007 CalcField = If (GST_Status = "Yes", Amount/8, "") I must be missing something, that was too easy. Link to comment Share on other sites More sharing options...
comment Posted July 27, 2007 Share Posted July 27, 2007 If GST is a tax, then this is not a good approach. Tax rates change, and they should not be hard-coded into calculation fields. P.S. Divide by 8? Who has a tax rate of 14.2857142857%? Link to comment Share on other sites More sharing options...
Kiwi Posted July 27, 2007 Share Posted July 27, 2007 (edited) If topaznz is in NZ then you should divide by 9. 100 / 12.5 = 8 but as you have already added the GST component you need to use 112.5 / 12.5 which is 9. hope that makes cents! Edited July 27, 2007 by Guest Link to comment Share on other sites More sharing options...
topaznz Posted July 27, 2007 Author Share Posted July 27, 2007 LOL yes yes, I'm a little bit of a simple novice with all this still - some may say thick but we won't go there. Thank you all for your help, will go take a crack at it! Your right Kiwi; divide by 9, for some stupid reason I was thinking I was entering GST exclusive figures. Thanks. bcooney; This is most likely 1 of several silly questions that will tap out of my finger-tips over time. Thank you for the calculation! Cheers everyone for your valuable assistance! Topaz Link to comment Share on other sites More sharing options...
Genx Posted July 27, 2007 Share Posted July 27, 2007 You guys have 12.5% gst? And you get charged on the basics - at least we only pay like 10% and don't get charged on our "non-luxury" items - like bread lol. But then you guys don't have Capital Gains Tax do you... hmmm, good place to make some money me thinks. Link to comment Share on other sites More sharing options...
bcooney Posted July 27, 2007 Share Posted July 27, 2007 I'd like to chime in with comment. I didn't realize this is a tax rate calculation. You should take the rate part out of this calculation and reference it instead. Store it in a Pref table. Then when the rate changes, you just change the pref value, not the calculation. Link to comment Share on other sites More sharing options...
comment Posted July 27, 2007 Share Posted July 27, 2007 LOL, if you're going to chime in with me, then suggest doing a lookup of the current rate and referencing the lookup, not the current rate. Link to comment Share on other sites More sharing options...
bcooney Posted July 30, 2007 Share Posted July 30, 2007 Ahh, of course, comment. Kinda assumed the lookup didn't I? Just thought that your point of separating out the rate was lost in the discussion. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6242 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