Maximo 7.6.1.2 API - TreeGrid.formula

java.lang.Object
- com.ibm.tivoli.maximo.miniapps.treegrid.TreeGrid.formula

Enclosing class:: TreeGrid

public static class TreeGrid.formula
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`static java.lang.String`	`alldependencyerrors` Gantt compute Correcting dependencies
`static java.lang.String`	`avedev` Calculations - cell formulas Formulas Calculates average deviation of column
`static java.lang.String`	`average` Calculations - cell formulas Formulas Calculates average of column values (sum/count)
`static java.lang.String`	`calc` Calculations - cell formulas Formulas Calculates formula for every row
`static java.lang.String`	`choose` Calculations - cell formulas Formulas
`static java.lang.String`	`count` Calculations - cell formulas Formulas Returns count of rows
`static java.lang.String`	`counta` Calculations - cell formulas Formulas Counts all non blank values in the column
`static java.lang.String`	`countac` Creating pivot tables Formulas
`static java.lang.String`	`countblank` Calculations - cell formulas Formulas Counts all blank values in the column
`static java.lang.String`	`countblankc` Creating pivot tables Formulas
`static java.lang.String`	`countc` Creating pivot tables Formulas
`static java.lang.String`	`ganttduration` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`ganttend` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`gantthasexclude` Gantt calendars – excluded dates / holidays Other settings
`static java.lang.String`	`ganttparts` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`ganttpercent` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`ganttpercentduration` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`ganttprogressline` Gantt display objects Mark
`static java.lang.String`	`ganttresourceextra` Gantt resources Resources calculations
`static java.lang.String`	`ganttresourcepeak` Gantt resources Resources calculations
`static java.lang.String`	`ganttresourcesextra` Gantt resources Resources calculations
`static java.lang.String`	`ganttresourceunits` Gantt resources Resources calculations
`static java.lang.String`	`ganttrunancestors` Gantt summary tasks Editable Run bar as summary of child Main bars
`static java.lang.String`	`ganttrundescendants` Gantt summary tasks Editable Run bar as summary of child Main bars
`static java.lang.String`	`ganttrunduration` Run bar Formulas
`static java.lang.String`	`ganttrunend` Run bar Formulas
`static java.lang.String`	`ganttrunmaxend` Gantt summary tasks Main bar as summary of child Run bars
`static java.lang.String`	`ganttrunminstart` Gantt summary tasks Main bar as summary of child Run bars
`static java.lang.String`	`ganttrunstart_` Run bar Formulas
`static java.lang.String`	`ganttrunsum` Gantt summary tasks Editable Run bar as summary of child Main bars
`static java.lang.String`	`ganttrunsumduration` Gantt summary tasks Main bar as summary of child Run bars
`static java.lang.String`	`ganttstart` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`join` Calculations - cell formulas Formulas
`static java.lang.String`	`joinc` Creating pivot tables Formulas
`static java.lang.String`	`joinsum` Calculations - cell formulas Formulas
`static java.lang.String`	`joinsumc` Creating pivot tables Formulas
`static java.lang.String`	`max` Calculations - cell formulas Formulas Returns maximum value from the column
`static java.lang.String`	`maxc` Creating pivot tables Formulas
`static java.lang.String`	`median` Calculations - cell formulas Formulas Returns median of column (middle value of range)
`static java.lang.String`	`min` Calculations - cell formulas Formulas Returns minimum value from the column
`static java.lang.String`	`minc` Creating pivot tables Formulas
`static java.lang.String`	`mode` Calculations - cell formulas Formulas Returns modus of column (the most frequent value in range)
`static java.lang.String`	`negav` Gantt resources Availability chart
`static java.lang.String`	`NodeName` formula
`static java.lang.String`	`product` Calculations - cell formulas Formulas Multiplies all values in column
`static java.lang.String`	`productc` Creating pivot tables Formulas
`static java.lang.String`	`rank` Calculations - cell formulas Formulas Returns position of val in sorted column (column is sorted ascending).
`static java.lang.String`	`split` Calculations - cell formulas Formulas
`static java.lang.String`	`stdev` Calculations - cell formulas Formulas Calculates standard deviation of column
`static java.lang.String`	`stdevp` Calculations - cell formulas Formulas Calculates standard deviation of column.
`static java.lang.String`	`sum` Calculations - cell formulas Formulas Sums all values in column
`static java.lang.String`	`sumc` Creating pivot tables Formulas
`static java.lang.String`	`sumflow` Main bar and Milestone Real Flow Sums all values in column with Range=1.
`static java.lang.String`	`sumjoin` Calculations - cell formulas Formulas
`static java.lang.String`	`sumjoinc` Creating pivot tables Formulas
`static java.lang.String`	`sumparts` Gantt summary tasks Main bar as summary of child Main bars
`static java.lang.String`	`sumrange` Calculations - cell formulas Formulas Sums all values in column with Range=1.
`static java.lang.String`	`sumrangec` Creating pivot tables Formulas
`static java.lang.String`	`sumsq` Calculations - cell formulas Formulas Sums all squares of values in column
`static java.lang.String`	`sumsqc` Creating pivot tables Formulas
`static java.lang.String`	`vara` Calculations - cell formulas Formulas Calculates the sample variance of column
`static java.lang.String`	`varp` Calculations - cell formulas Formulas Calculates the sample variance of column.

Constructor Summary

Constructors
Constructor and Description

formula()

Constructors
Constructor and Description
`formula()`

Method Summary
- Methods inherited from class java.lang.Object
  equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - NodeName
```
public static final java.lang.String NodeName
```
    formula
    
    See Also:
    
    Constant Field Values
  - alldependencyerrors
```
public static final java.lang.String alldependencyerrors
```
    Gantt compute
    Correcting dependencies
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttCompute.htm#formulaalldependencyerrors
    See Also:
    
    Constant Field Values
  - avedev
```
public static final java.lang.String avedev
```
    Calculations - cell formulas
    Formulas
    Calculates average deviation of column
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulaavedev
    See Also:
    
    Constant Field Values
  - average
```
public static final java.lang.String average
```
    Calculations - cell formulas
    Formulas
    Calculates average of column values (sum/count)
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulaaverage
    See Also:
    
    Constant Field Values
  - calc
```
public static final java.lang.String calc
```
    Calculations - cell formulas
    Formulas
    Calculates formula for every row
```
 (string formula, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulacalc
    See Also:
    
    Constant Field Values
  - choose
```
public static final java.lang.String choose
```
    Calculations - cell formulas
    Formulas
```
 (value, values[], items[],custom)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulachoose
    See Also:
    
    Constant Field Values
  - count
```
public static final java.lang.String count
```
    Calculations - cell formulas
    Formulas
    Returns count of rows
```
 (string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulacount
    See Also:
    
    Constant Field Values
  - counta
```
public static final java.lang.String counta
```
    Calculations - cell formulas
    Formulas
    Counts all non blank values in the column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulacounta
    See Also:
    
    Constant Field Values
  - countac
```
public static final java.lang.String countac
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulacountac
    See Also:
    
    Constant Field Values
  - countblank
```
public static final java.lang.String countblank
```
    Calculations - cell formulas
    Formulas
    Counts all blank values in the column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulacountblank
    See Also:
    
    Constant Field Values
  - countblankc
```
public static final java.lang.String countblankc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulacountblankc
    See Also:
    
    Constant Field Values
  - countc
```
public static final java.lang.String countc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulacountc
    See Also:
    
    Constant Field Values
  - ganttduration
```
public static final java.lang.String ganttduration
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string ganttcol, int plan = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttduration
    See Also:
    
    Constant Field Values
  - ganttend
```
public static final java.lang.String ganttend
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string ganttcol, int plan = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttend
    See Also:
    
    Constant Field Values
  - gantthasexclude
```
public static final java.lang.String gantthasexclude
```
    Gantt calendars – excluded dates / holidays
    Other settings
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttCalendars.htm#formulagantthasexclude
    See Also:
    
    Constant Field Values
  - ganttparts
```
public static final java.lang.String ganttparts
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string ganttcol, int plan = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttparts
    See Also:
    
    Constant Field Values
  - ganttpercent
```
public static final java.lang.String ganttpercent
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string ganttcol, string weightcol, int round, int plan = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttpercent
    See Also:
    
    Constant Field Values
  - ganttpercentduration
```
public static final java.lang.String ganttpercentduration
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string durationcol, string percentcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttpercentduration
    See Also:
    
    Constant Field Values
  - ganttprogressline
```
public static final java.lang.String ganttprogressline
```
    Gantt display objects
    Mark
```
 (string date, string left = 'A', string right = '0', int none = 15, string start = null, string end = null, string duration = null, string complete = null, string ganttcol = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttDisplay.htm#formulaganttprogressline
    See Also:
    
    Constant Field Values
  - ganttresourceextra
```
public static final java.lang.String ganttresourceextra
```
    Gantt resources
    Resources calculations
```
 (string resource, string def)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttResources.htm#formulaganttresourceextra
    See Also:
    
    Constant Field Values
  - ganttresourcepeak
```
public static final java.lang.String ganttresourcepeak
```
    Gantt resources
    Resources calculations
```
 (string resource, string def)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttResources.htm#formulaganttresourcepeak
    See Also:
    
    Constant Field Values
  - ganttresourcesextra
```
public static final java.lang.String ganttresourcesextra
```
    Gantt resources
    Resources calculations
```
 (string def)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttResources.htm#formulaganttresourcesextra
    See Also:
    
    Constant Field Values
  - ganttresourceunits
```
public static final java.lang.String ganttresourceunits
```
    Gantt resources
    Resources calculations
```
 (string resource, string def)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttResources.htm#formulaganttresourceunits
    See Also:
    
    Constant Field Values
  - ganttrunancestors
```
public static final java.lang.String ganttrunancestors
```
    Gantt summary tasks
    Editable Run bar as summary of child Main bars
```
 (string ganttcol = "", string condition = "", int type = "", int plan = 0)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttrunancestors
    See Also:
    
    Constant Field Values
  - ganttrundescendants
```
public static final java.lang.String ganttrundescendants
```
    Gantt summary tasks
    Editable Run bar as summary of child Main bars
```
 (string ganttcol = "", string condition = "", int type = "", int plan = 0)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttrundescendants
    See Also:
    
    Constant Field Values
  - ganttrunduration
```
public static final java.lang.String ganttrunduration
```
    Run bar
    Formulas
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttRun.htm#formulaganttrunduration
    See Also:
    
    Constant Field Values
  - ganttrunend
```
public static final java.lang.String ganttrunend
```
    Run bar
    Formulas
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttRun.htm#formulaganttrunend
    See Also:
    
    Constant Field Values
  - ganttrunmaxend
```
public static final java.lang.String ganttrunmaxend
```
    Gantt summary tasks
    Main bar as summary of child Run bars
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttrunmaxend
    See Also:
    
    Constant Field Values
  - ganttrunminstart
```
public static final java.lang.String ganttrunminstart
```
    Gantt summary tasks
    Main bar as summary of child Run bars
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttrunminstart
    See Also:
    
    Constant Field Values
  - ganttrunstart_
```
public static final java.lang.String ganttrunstart_
```
    Run bar
    Formulas
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttRun.htm#formulaganttrunstart
    See Also:
    
    Constant Field Values
  - ganttrunsum
```
public static final java.lang.String ganttrunsum
```
    Gantt summary tasks
    Editable Run bar as summary of child Main bars
```
 (string ganttcol = "", string condition = "", int type = "", int plan = 0)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttrunsum
    See Also:
    
    Constant Field Values
  - ganttrunsumduration
```
public static final java.lang.String ganttrunsumduration
```
    Gantt summary tasks
    Main bar as summary of child Run bars
```
 (string ganttcol)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttrunsumduration
    See Also:
    
    Constant Field Values
  - ganttstart
```
public static final java.lang.String ganttstart
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string ganttcol, int plan = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulaganttstart
    See Also:
    
    Constant Field Values
  - join
```
public static final java.lang.String join
```
    Calculations - cell formulas
    Formulas
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulajoin
    See Also:
    
    Constant Field Values
  - joinc
```
public static final java.lang.String joinc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulajoinc
    See Also:
    
    Constant Field Values
  - joinsum
```
public static final java.lang.String joinsum
```
    Calculations - cell formulas
    Formulas
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulajoinsum
    See Also:
    
    Constant Field Values
  - joinsumc
```
public static final java.lang.String joinsumc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulajoinsumc
    See Also:
    
    Constant Field Values
  - max
```
public static final java.lang.String max
```
    Calculations - cell formulas
    Formulas
    Returns maximum value from the column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulamax
    See Also:
    
    Constant Field Values
  - maxc
```
public static final java.lang.String maxc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulamaxc
    See Also:
    
    Constant Field Values
  - median
```
public static final java.lang.String median
```
    Calculations - cell formulas
    Formulas
    Returns median of column (middle value of range)
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulamedian
    See Also:
    
    Constant Field Values
  - min
```
public static final java.lang.String min
```
    Calculations - cell formulas
    Formulas
    Returns minimum value from the column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulamin
    See Also:
    
    Constant Field Values
  - minc
```
public static final java.lang.String minc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulaminc
    See Also:
    
    Constant Field Values
  - mode
```
public static final java.lang.String mode
```
    Calculations - cell formulas
    Formulas
    Returns modus of column (the most frequent value in range)
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulamode
    See Also:
    
    Constant Field Values
  - negav
```
public static final java.lang.String negav
```
    Gantt resources
    Availability chart
```
 (string availability)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttResources.htm#formulanegav
    See Also:
    
    Constant Field Values
  - product
```
public static final java.lang.String product
```
    Calculations - cell formulas
    Formulas
    Multiplies all values in column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulaproduct
    See Also:
    
    Constant Field Values
  - productc
```
public static final java.lang.String productc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulaproductc
    See Also:
    
    Constant Field Values
  - rank
```
public static final java.lang.String rank
```
    Calculations - cell formulas
    Formulas
    Returns position of val in sorted column (column is sorted ascending). Starting from 0.
```
 (string col, object val)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formularank
    See Also:
    
    Constant Field Values
  - split
```
public static final java.lang.String split
```
    Calculations - cell formulas
    Formulas
```
 (value, separator)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulasplit
    See Also:
    
    Constant Field Values
  - stdev
```
public static final java.lang.String stdev
```
    Calculations - cell formulas
    Formulas
    Calculates standard deviation of column
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulastdev
    See Also:
    
    Constant Field Values
  - stdevp
```
public static final java.lang.String stdevp
```
    Calculations - cell formulas
    Formulas
    Calculates standard deviation of column. column is the selection of data.
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulastdevp
    See Also:
    
    Constant Field Values
  - sum
```
public static final java.lang.String sum
```
    Calculations - cell formulas
    Formulas
    Sums all values in column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulasum
    See Also:
    
    Constant Field Values
  - sumc
```
public static final java.lang.String sumc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulasumc
    See Also:
    
    Constant Field Values
  - sumflow
```
public static final java.lang.String sumflow
```
    Main bar and Milestone
    Real Flow
    Sums all values in column with Range=1. It just creates new range from all intervals and updates it to not contain duplicate value cross intervals.
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttMain.htm#formulasumflow
    See Also:
    
    Constant Field Values
  - sumjoin
```
public static final java.lang.String sumjoin
```
    Calculations - cell formulas
    Formulas
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulasumjoin
    See Also:
    
    Constant Field Values
  - sumjoinc
```
public static final java.lang.String sumjoinc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulasumjoinc
    See Also:
    
    Constant Field Values
  - sumparts
```
public static final java.lang.String sumparts
```
    Gantt summary tasks
    Main bar as summary of child Main bars
```
 (string startdatecol, string durationcol, string units)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/GanttSummary.htm#formulasumparts
    See Also:
    
    Constant Field Values
  - sumrange
```
public static final java.lang.String sumrange
```
    Calculations - cell formulas
    Formulas
    Sums all values in column with Range=1. It just creates new range from all intervals and updates it to not contain duplicate value cross intervals.
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulasumrange
    See Also:
    
    Constant Field Values
  - sumrangec
```
public static final java.lang.String sumrangec
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulasumrangec
    See Also:
    
    Constant Field Values
  - sumsq
```
public static final java.lang.String sumsq
```
    Calculations - cell formulas
    Formulas
    Sums all squares of values in column
```
 (string col = null, string condition = null, int type = 0, string server = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulasumsq
    See Also:
    
    Constant Field Values
  - sumsqc
```
public static final java.lang.String sumsqc
```
    Creating pivot tables
    Formulas
```
 (string col = null, string headerid = null, string condition = null)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/Pivot.htm#formulasumsqc
    See Also:
    
    Constant Field Values
  - vara
```
public static final java.lang.String vara
```
    Calculations - cell formulas
    Formulas
    Calculates the sample variance of column
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulavara
    See Also:
    
    Constant Field Values
  - varp
```
public static final java.lang.String varp
```
    Calculations - cell formulas
    Formulas
    Calculates the sample variance of column. column is the selection of data.
```
 (string col)
 
```
    TreeGrid API http://www.treegrid.com/treegrid/Doc/CellFormula.htm#formulavarp
    See Also:
    
    Constant Field Values
- Constructor Detail
  - formula
```
public formula()
```

Class TreeGrid.formula

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

NodeName

alldependencyerrors

avedev

average

calc

choose

count

counta

countac

countblank

countblankc

countc

ganttduration

ganttend

gantthasexclude

ganttparts

ganttpercent

ganttpercentduration

ganttprogressline

ganttresourceextra

ganttresourcepeak

ganttresourcesextra

ganttresourceunits

ganttrunancestors

ganttrundescendants

ganttrunduration

ganttrunend

ganttrunmaxend

ganttrunminstart

ganttrunstart_

ganttrunsum

ganttrunsumduration

ganttstart

join

joinc

joinsum

joinsumc

max

maxc

median

min

minc

mode

negav

product

productc

rank

split

stdev

stdevp

sum

sumc

sumflow

sumjoin

sumjoinc

sumparts

sumrange

sumrangec

sumsq

sumsqc

vara

varp

Constructor Detail

formula