1 Reply Latest reply: Aug 28, 2013 6:58 AM by George_Johnson RSS

    Multiply a Field by a Fixed Number

    Crystal J27

      I want to multiply a field called "Total Pins Requested:" by $4.25 and have the answer populate in a field called "Total Amount:" Can someone please help me?

        • 1. Re: Multiply a Field by a Fixed Number
          George_Johnson CommunityMVP

          In the Total Amount field, you can use the following in the Simplified fIeld notation area (Calculate tab):

           

          4.25 * Total\ Pins\ Requested

           

          Note that each space is escaped with a backslash. This wouldn't be needed if you removed the spaces from the field name.

           

          The following custom Calculate JavaScript would also work:

           

          // Custom Calculate script for "Total Amount"

          event.value = 4.25 * getField("Total Pins Requested").value;