Sum columns based on radio button answer

hi,

 

i trying create if statement sum hours in table based upon answer given radio button in lifecycle designer.  based upon answer of radio button, tables displayed or hidden.  wanted use same logic in calculation field.  below both radio button formula , calculation field formula.  statements in calculation field work separately, not when trying work off radio button.

 

i open suggestions if there better way accomplish situation.

 

thank you.

 

this fomula in radio button (java script):

 

if ( this.yes.rawvalue == 1 )

        {

        tasksrow.presence = "visible";

        working.presence = "hidden"

        }

    else

        {

        tasksrow.presence = "hidden";

        working.presence = "visible";

        }

   

this formula in calculation field (formcalc):

 

 

if (form1.#subform[0].projmarketsect.qa_phase_subform.empprojtablecells.questionrow.

subform1.radiobuttonlist.yes.rawvalue == 1 )

then

sum(form1.#subform[0].projmarketsect.project_table.empprojinfotable.

empprojinforow.empprojtablecells.tasksrow.taskssubform.table2[*].row1[*].task_hours_field);

else

$.rawvalue = sum(form1.#subform[0].projmarketsect.project_table.empprojinfotable.

empprojinforow.empprojtablecells.

working.subform3.table6[*].row1[*].hours_field);

endif

More discussions in LiveCycle Forms

adobe