3 Replies Latest reply on May 1, 2015 11:06 AM by Splatt

    Adding up dollar amounts from text field populated with letter and numbers

    Splatt

      I have a "TotalCost"  Text Field. I am looking for it to show the costs of items in another Text Field. That text field could look like, "item1 ($500.00), item2 (65.78), item3, item4 ($.0.00)". What I am looking to do is have the "TotalCost" show the sum of all the dollar values, and adjust properly as items are added or removed. I believe a regular expression is needed to match the and I came up with /\$\d{1-4}\.\d{2}/ although I'm lost on how to implement the code for the TotalCost field for what I'm trying to do.

       

      Appreciate any insight.