The issue is the $ sign in the dropdown. By adding the $ sign you are making this a string and not a number. To fix this you can do it in one of two ways. You can remove the dollar sign or you can leave the dolloar sign in plcae and take advantage of how Dropdowns work. You can have a specific value shown (this is the Displayed Value) but then have a completely different value used when asked for the DDList value (this is the data value). So I modified the DDLists to have a different data value (without the $) then modified the command to use the data value for the calculation. I changed the calculation to run on the Calculate event of the Total field. The calculate event will fire when the form loads as well as any time a referenced field in the calculate changes. So when you select a rate the total field will fire automagically!
Oh by the way the data values are set on the binding tab of the DropDown field.
I have attached a modified version of the form you sent.
Paul
