2283381 - Calculated / Transient fields are inconsistent or blank in reporting

• Calculated/transient fields from BizX are not available for reporting (Table, Detailed Reporting, Advanced Reporting, Stories)
• Calculated/transient are available to be selected in the report, but there is no data within it
• Data reported for a few fields is inconsistent
• Including and not limited to Time in Job, Range Penetration, Fixed Pay, Variable Pay, etc

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors HCM Suite
• SAP SuccessFactors People Analytics
• SAP SuccessFactors Employee Central

Calculated (transient) fields are not stored to the database as they are calculated on the fly and displayed in the user interface. Therefore, these fields are not supported and not available for reporting.

As a workaround, create a calculated column in Stories / Canvas reports.

See KBA 2686340 as an example of Annualized Salary and KBA 2339132 on Compa Ratio and Range Penetration for your reference.

• This is not applicable to on Table reporting as it is not possible to create calculated columns.

Creating calculated columns is out of the support team scope, our work is focused on bugs and malfunctions, so if you need help to create it, please contact your partner or professional services:

• 2149831 - Contacting Professional Services, Partner and Account Management Team - SuccessFactors Cloud

NOTE: onView, Calculated fields are transient fields and so no data is saved to the system. The Values will dynamically calculate each time that you visit the users Biographical Information. You will not be able to report on the value, so long as the rule is set to trigger onView. 

To resolve this, you have two options: 

1. Save the value manually if you wish to include it in reporting. 

2. Create a new custom field along with a default rule. This rule will default the value of example `custom-date1` to the new custom field, which will then be reportable. 

• 2686340 - How to create calculated column for "Annualized Salary" field in Advance Reporting (Realms)
• 2324356 - Annualized Salary in Ad Hoc / Detailed reporting is blank or incorrect
• 2339132 - Is it possible to create ad hoc report of "Compa Ratio and Range Penetration"
• 3003502 - MDF object Transient Field is not Reportable in Adhoc Report and Advance Reporting (Report Canvas) Reports 
• 2620429 How to - Creating a Business Rule to Calculate Service Length Using Custom Field (custom-double) in Employment Details

Time, in, Job, Calculated, transient, Transient, Fields,Compa, Ratio, Report, Online, Designer, Canvas, Table, Compa Ratio, Range Penetration, Annualized Salary. , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-EC , Employee Central , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To