User Tools

Site Tools

Trace:
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:04]
rnadler 		start:calculated_fields [2017/01/28 08:44] (current)
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 10: Line 10:
  
 **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 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.1472483047.txt.gz ยท Last modified: 2016/08/29 11:04 by rnadler

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki