User Tools

Site Tools


start:calculated_fields

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
start:calculated_fields [2016/08/29 11:06]
rnadler
start:calculated_fields [2017/01/28 08:44]
rnadler
Line 1: Line 1:
-**Calculated Fields**+==== Calculated Fields ====
  
 Calculated fields are supported with the textbox table question style. Calculated fields are supported with the textbox table question style.
Line 11: Line 11:
 **Calculations**:  =r2c2*r2c3/200  or = r1c1/r1c4*100%  (the percent sign is optional and will add a % sign to the result) **Calculations**:  =r2c2*r2c3/200  or = r1c1/r1c4*100%  (the percent sign is optional and will add a % sign to the result)
  
-**If then logic**: =(if(r2c2==0) s = 0; else if(r2c2 >= 1) s=2; else s = 3;  +**If else logic**: =(if(r2c2==0) s = 0; else if(r2c2 >= 1) s=2; else s = 3;  
  
 Note about row and column references:  The tables include a column and row for table labels.  These are row 1 and column 1.  When referencing cells the first textbox cell is typically r2c2. Note about row and column references:  The tables include a column and row for table labels.  These are row 1 and column 1.  When referencing cells the first textbox cell is typically r2c2.
start/calculated_fields.txt ยท Last modified: 2017/01/28 08:44 by rnadler