Hmmm... that wasn't working for me. I ended up having it calculate the Total when I saved the record and that works good for me at the moment. thanks for your help.
Hmm thanks for posting @ADiecidue and thanks @ScottR and @edurmush for helping troubleshoot! It seems like @edurmush's suggestion here should have done the trick but glad you have a workaround calculating Total when you save the record for now.