April 4, 200718 yr 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?
April 4, 200718 yr Is this what you are looking for? MyField1 user types in $1,000 MyInterestRateField user types in 16 MyCalcField = MyField1 * (MyInterestRateField /100)
April 4, 200718 yr 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 :
April 5, 200718 yr 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
Create an account or sign in to comment