11/22/2023 0 Comments Formula creator based on data pointsWhen you select a function from either the Math, Text, or Date function drop-down list, the function will be added to the Equation Editor followed by a pair of parentheses. When creating a new equation, there are several formatting rules that apply across all fields and functions:Ī. The Equation Editor refers to the box in which you enter your equation (labelled "Enter Equation" with placeholder text). Equation- this is where you can define your equation by selecting fields from the Add Field drop-down list, selecting your desired Math, Text, or Date function, and configuring your fields and functions within the Equation Editor.Description- this is where you can optionally provide a brief description of this field for your own reference.For instance, "Day of Month" or "Time Difference". Name- this is where you can name your Equation field.When creating an Equation field, there are several settings you can customize such as those highlighted in the image below. To create an Equation field, select the Equation field type from the Equation fields type category on the Add Field Menu within the data table that you would like to add this Equation field. Watch the brief equations overview video below to get a general insight of how you can use equations to empower your field values. Within this article we will explore the different functions you can use to create equations on your values, and we will also demonstrate how to create equations such as the sample equation listed above. Equation Fields enable more complex formula functions to be run on your values.įor instance, you can create an Equation formula to extract the name of the month from your date values.Įquation fields can be used in combination with Basic Formula fields and can be nested within other Equation fields.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |