Message-ID: <2062748898.15631.1711725701946.JavaMail.confluence@ip-172-16-1-18.us-west-2.compute.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_15630_175776347.1711725701943" ------=_Part_15630_175776347.1711725701943 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html The Formula Builder Tab

The Formula Builder Tab

=20
=20
=20
=20

The Formula Builder tab is where you create the formula for your calcula= ted field or measure. This tab includes the following

  • Formula Entry Box: shows the current for= mula for your calculated field. You can edit the formula by typing directly= in the panel, or using the operator buttons and the Fields and Measures an= d Functions selection lists. Formulas must use the following syntax: <= /span>

    • Labels for fields and measures must be in double quotes ("): "= Customer ID", "Date ordered". 

    • Text must be in single quotes ('): '--'. 

    • Levels must be in single quotes ('): 'ColumnGroup', 'Total'.&n= bsp;

  • Operator buttons: click these buttons to= insert the operator in the Formula entry box. 

  • Fields and Measures list: lists all the = fields and measures currently in your Ad Hoc view, including any calculated= fields or measures you have already created. Double-click a name on the li= st to insert it into the Formula entry box. Note that field and measure nam= es must be enclosed in double quotes. For example: "Region". This is done a= utomatically when you insert a field by double-clicking. 

  • Functions: lists all the available funct= ions you can use in your formula. Double-click the name of a function to in= sert it in the Formula Entry Box. 

  • Function Description panel: gives a brie= f description of the function selected in the Functions list, if any. =

  • Show arguments in formula (checkbox): wh= en this checkbox is enabled, double-clicking on a function name in the = ; Functions list adds the full description to th= e  Formula Entry Box; when the checkbox is disab= led, double-clicking on a function name adds only the function. For example= , double-clicking "Round" adds "Round("NumberFieldName", Integer)" when the= checkbox is enabled, and adds "Round()" when the checkbox is disabled. If = you enable this checkbox, you can double-click on a string, such as "Number= FieldName", and then replace it by double-clicking a name in the  = ;Fields and Measures list. 

  • Validate button: checks the formula for = syntax errors, such as missing parentheses or quotes. Your field must valid= ate before you can create it. Syntax validation does not guarantee that you= r formula will give the results you want=E2=80=94validation just ensures th= at the construction of your formula is consistent and logical. =

=20
=20 =20
=20
------=_Part_15630_175776347.1711725701943--