Skip to main content
Question

formula not calculating the total until after saving the record

  • December 15, 2018
  • 0 replies
  • 94 views

See pic below. I created three fields that will calculate the final total into the field "contract monthly term total".  This field is a currency-formula type. it doesn't show the total until after i click save.  As you see, there isn't a total even though i put in numbers for the other fields.  The amount sold field are currency type and the contract term is numeric. The formula is [Contract Term]*[Contract Monthly Amount Sold]+[Contract One-Time Amount Sold]. Is there a way to make it show the total before saving the ticket?  Thank you.
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
Try hitting Tab on the keyboard after you enter all values, does it calculate for you then?


You have to tab out of the field for it to recalculate. Same as Excel that way.