Creating Formulas

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Explain the uses of formulas, such as finding the time difference between two date fields.

Create Formulas for Multiple Reports

There are many great fields available within SAP Fieldglass Analytics, many of which satisfy the needs of organizations that use the product. However, there are times when a data field is required that does not already exist, and this is where Formulas come in.

Mateo is asked to provide a report with workers nearing their end date. He needs a field to show how many days are left in the worker’s assignment. This is not a field in the data dictionary, so Mateo will need to create a formula to calculate the days until the worker end date.

After the formula is created, Mateo will be able to add the formula field to any reports. Since Mateo is an SAP Fieldglass administrator, he has the Formula Field user role permissions to be able to create formulas.

Log in to track your progress & complete quizzes