math functions on radio group values

[Former Community Member]

I have a form with 8 radio groups. Each group has 6 options, each with a value between 0-6.

I need to preform the following after a selection has been made on each group.

[Sum of all statements selected / (# of sections with a statement selected x 5)] x 100

and I want the resulting number to appear in a text box at the bottom of the page.

Please, any help would be nice!

[Former Community Member · Accepted solution]

Here is a sample of what I think you want .....the code is on the calculate of the Total field at the bottom.

paul

[Former Community Member]

Thank you, that was perfect !

Only thing was.. My groups had values from 0-5 not 1-6, but that was easy to change.

If all the sections are a Zero value.. How do I get the answer to show a Zero?

currently when its equal to zero.. it shows a blank answer in the box.

[Former Community Member]

By default the numeric field will show a blank to represent a zero .....allthough if you asked for the rawvalue it woudl report zero. You can define how you want the 0 value to be shown. On teh field click on the Object palette and choose the Patterns button. This will start another dialog. Click the Show zero and then in the field below indicate how you want to display your zero. In my case I put a 0 but you coudl put empty or anything you want. See the screen shot below:

Paul