Configure function field not displaying all the values

[msm4]

Hello Team,

I am working on Configure function field on reports to calculate the cost variance on the project, here I need to calculate the project's Projected Capital and Actual Capital, but while searching the respective fields I don't find them under the fields section.

Can somebody help me understand why it is so?

Also I found this on the field dictionary : where the function field is unchecked. Is this related to this?

Thanks,

msm.

[Community Alums]

Hi @msm ,

Create a function field to be able to group and stack a report by the results of the field's calculation.

Role required: admin, function_field_admin

Each function field requires a label, a return type, and a definition. The definition consists of the operation and one or more fields that the operation is performed on.

Note: It is not possible to change the label or the return type after you save a function field. If necessary, deactivate the function field and start again.

Procedure

1. Navigate to Reports > Create New.
2. Select the report you want to add a function field to.
   When you configure a function field on a table, it is available anywhere you use the table on the Now Platform, including any report on the same table. For example, a function field that calculates the age of open incidents is available for all reports on the incident table.
3. Open the Configure tab and click Configure function field.
4. (Optional) Enter the field name in the search bar to see if someone has already created the function field. Point to the search results to see the function definition.
5. Click Create.
   There can be a maximum of 20 active function fields on the table the report is based on. If the table already has 20 function fields, a creator of one of the fields or a platform_admin must deactivate or delete one.
6. Specify the Label. The label is the name users can see when they group or stack data in a report.
7. Select the Return type.
   The return type is the kind of information the function produces. For example, the datediff() function returns a Duration type because it calculates the duration between two dates.

   Note: You do not see a message if your return type is not a logical result of the function.
8. Select the Operation.
   The Syntax text box shows the name of the function preceded by glidefunction:.

   

9. Select the fields the function operates on. Some functions require only one field; some require two or three fields. See Report on function fields. Make sure that you separate the fields with commas.
10. When the syntax is correct, you can save the function field.
    When the syntax is incorrect, you see the message: Syntax error: Invalid expression. You may also see other messages.

    

    Also watch this video: https://www.youtube.com/watch?v=6bzzJNm7YHk

    Mark my answer correct & Helpful, if Applicable.

    Thanks,

    Sandeep

[msm4]

Hi sandeep,

What I was trying to ask is, why all the fields are not available from the table on the field selectio of add field?

thank you,

msm.

[Community Alums]

It goes as per the table, meaning if your table has those fields then would show them.

[Lavern Towne]

You can configure up to 20 active function fields per table for use in reporting using the Report Designer. When you configure a function field on a table, you can group or stack by the results of the function calculation.

 alaskasworld.com