Returning the "option" in a Table Option Calculation that references a Table Option field with scores
Previously, if you assigned scores to an option field being used in a table option calculation it returned the value and not the text (as shown here)
The scores that are assigned to the options in the "Status" field
In the Option Calculation Field you can now write in "option" before the field name and it will return the option instead of the value
The calculation will then return the option and not the option's value
You ONLY need to write in option when there is a score assigned to the options that you are using the table option calculation.
The image in the step here shows that the Current Status fields are not being pulled through. This is because the scores were removed for the option in the "Status" table field, but the Table Option Calculation is still written as option(Status).
Remember:
If you do NOT have scores assigned to the options, the system will only pull through the option, so just write the field name e.g. Status.
If you DO have scores assigned to the options, then you need to use the option function and write option(Status) to pull through the options and not the scores.
0 Comments
Add your comment