The following page describes the syntax you can apply when you want to build custom formulas in your report tables. You find the custom formula section here:

Formula | Description | Example |
CellValue(["[ROW-NAME]"],"[COLUMN-NAME]").MissingsCount | Returns the count of Interviews with Missings for a specified cell. If the RowName is not specified then the current row is assumed. | CellValue(null,"Column1").MissingsCount
CellValue("Row1","Column1").MissingsCount |
CellValue(["[ROW-NAME]"],"[COLUMN-NAME]").NaCount | Returns the count of Interviews with N/A for a specified cell. If the RowName is not specified then the current row is assumed. | CellValue(null,"Column1").NaCount
CellValue("Row1","Column1").NaCount |
CellValue(["[ROW-NAME]"],"[COLUMN-NAME]").Value | Returns the calculated Value for a specified cell. If the RowName is not specified then the current row is assumed. | CellValue(null,"Column1").Value
CellValue("Row1","Column1").Value |
CellValue(["[ROW-NAME]"],"[COLUMN-NAME]").ResponseCount | Returns the count of Interviews for a specified cell. If the RowName is not specified then the current row is assumed. | CellValue(null,"Column1").ResponseCount
CellValue("Row1","Column1").ResponseCount |
Custom formula related to segments
Formula | Description |
RowResult.MissingsCount | Returns the count of Interviews with Missings for the current segment. |
RowResult.NaCount | Returns the count of Interviews with N/A for the current segment. |
RowResult.ResponseCount | Returns the count of Interviews for the current segment. |
SegmentValue(name) | Returns the Segment Value of the current column for the given segment name. |
Custom formula related to the Table
Formula | Description |
DataSourceResult.MissingsCount | Returns the count of Interviews with Missings of the whole Table not based on a variable. |
DataSourceResult.NaCount | Returns the count of Interviews with N/A of the whole Table not based on a variable. |
DataSourceResult.ResponseCount | Returns the count of Interviews |
CurrentRowName | Returns the RowName which is currently calculated |
CurrentColumnName | Returns the ColumnName which is currently calculated |
Multiline Custom Formula
If you want to create a multi line script, please use the return command in the start and ; in the end:
return (CellValue("Row1","Ginger_1_Average_f2bf-21db").Value
+ CellValue("Row2","Ginger_1_Average_f2bf-21db").Value
+ CellValue("Row3","Ginger_1_Average_f2bf-21db").Value
+ CellValue("Row4","Ginger_1_Average_f2bf-21db").Value
+ CellValue("Row5","Ginger_1_Average_f2bf-21db").Value) / 5;
The full scope of the script editor is described in the dotnet language reference: