Cobra Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Formula Tags

Formulas are entered in the same format as any Excel formula.

Attention: For more information on formulas, see Project Pane Column Descriptions.

The table below provides information on formulas based on relative cell references.

Tag Sections Report Types Description
{=SUM(WorkPackage.Bac)} HeaderGroup CAP, CPR Replaces the entity tag with a range.
{=Cell[R,C-2] - Cell[R, C-1]} HeaderGroup All Formulas based on relative cell references. This indicates taking the value in the cell two columns to the left and on the same row as the current cell (where the formula is) and subtracting the value in a cell on a column to the left and on the same row as the current cell.
{=IF(Cell[R-6,C]=0,"N/A",Cell[R-5,C]/Cell[R-6,C])} HeaderGroup All Mixed Excel, cell formulas
{Column.Total} HeaderGroup CPR Places the formula =SUM(range) for the column.
{=Cell[<RowLabel>, C]} HeaderGroup All Formulas based on a row label. You can specify a row label that has been defined using the {RowLabel:<RowLabel>} tag instead of R for the first parameter.

Row labels must be unique. If the same row label is defined on more than one row, then only the first one will be recognized.

Do not specify a row label in a section defined using {CriteriaN} notation because this will cause the same row label to be generated for each criterion.

<RowLabel>-1 is supported but other offsets are not.

A row label from a different entity or criterion can be referenced.