July 13, 200124 yr Newbies I created a field with a calculation...that combines the following information: Units*Price per unit=Total Cost. However, if the total cost is less than $51.00 I would like it to default to $51.00. That is the minimum charge. I have tryed several different formulas in the "specify calculation" area, but can't seem to figure it out. Any suggestions?
July 13, 200124 yr This should work Methinks: TotalCost = If((Units*Priceperunit )> 51, Units*Priceperunit, 51) This should check and see if the result will be greater than 51 dollars, if so it uses the evaluated amount, if not, it will use the default amount of 51. Though I would reccommend making a global field somewhere called "lowest price" or something and substituting that for the 51 in the calculation so the lowest price can be updated without getting into calculation definitions later on, especially if you are not the end user. Usually I'd make a "manager tools" page that would allow editing of values like that. IMO (in my opinion) hard coding specific values into a field definition is *usually* not as good as using a global field, especially if there is a chance the value will ever change.
Create an account or sign in to comment