cul8ter Posted April 4, 2007 Posted April 4, 2007 Calculation within a newly created record. In field 1 i input $1,000. and in field 2 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas?
sbg2 Posted April 4, 2007 Posted April 4, 2007 Is this what you are looking for? MyField1 user types in $1,000 MyInterestRateField user types in 16 MyCalcField = MyField1 * (MyInterestRateField /100)
gannon Posted April 4, 2007 Posted April 4, 2007 Field_1 is the full number Field_2 is the percentage You then need a field that will contain the result? Field_3 is the value of the percentage = Field_1*Field_2/100 Of course, the $ sign and the % sign are not part of the fields data... even though it could, but not good Hope that I understood your question :
comment Posted April 5, 2007 Posted April 5, 2007 Isn't this the third time you have asked the same question?
Raybaudi Posted April 5, 2007 Posted April 5, 2007 Ok This is my third reading of your post... IF you want to have always a fixed interest of 160, AND IF your second example is wrong ( you write 3,000 , but you wished to write 2,000 ) THAN: Field 2 calculation is : fixed interest*100/field1
Recommended Posts
This topic is 6503 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