2 Replies Latest reply on Aug 30, 2011 9:38 PM by brutuswa

    Calculation from a Radio button selection

    brutuswa

      Title

      Calculation from a Radio button selection

      Post

      I have a field of radio buttons with 4 choices.  I have another calulation field.

      How do I get the calculation field to make a calculation depending upon which radio button is pushed?

      I've looked at script triggers but that only seems to apply for the whole radio button field, no differentiation of which radio button is selected.

      tia

      Brett

        • 1. Re: Calculation from a Radio button selection
          LaRetta_1

          A calculation will update whenever values in fields it references changes IF the fields are in the same record.  So you will not need a script.  Create calculation (result is text ) something like:

          Case (
          yourRadioButton = "Often" ; 1 ;
          yourRadioButton = "Sometimes" ; 2 ;
          YourRadioButton = "Rarely ; 3 ;
          "Never"
          )

          Is this what you are thinking that you need?

          • 2. Re: Calculation from a Radio button selection
            brutuswa

            Thanks LaRetta

            It ended up being... Case (Discount = "1 Monthly" ; (Quote_Gross_InOut /100)* 20 )

            The other radio buttons will give different percentage discount.  The calc field will be hidden and the discount will be subtracted from the Gross figure to produce a Nett figure.

            Thanks for your helpCool

             

            Brett