3662560 - Compensation standard story reports showing "Internal error occurred while processing" error message

Standard story reports for Compensation and Variable pay are showing up internal server error when previewing the query or in story view intermittently for SF_COM_Gender_Pay_Gap_Analysis_v2.0 or SF_COM_Annual_Compensation_Analysis_v2.0 reports

• SAP SuccessFactors 
  • Analytics & Reporting  (Ad Hoc, YouCalc, ORD)
    • Story Reports
      • Query Designer - Filter, Calculated Column, Params

• login to instance
• open the compensation story report 
• navigate to the story report query
• preview the query -> it shows internal server error

• This issue is due to the calculated column named: SCALEDANNUALAMOUNT used in the story reports which has the ANNUALAMOUNT divided by FTE.
• It is most likely due to the presence of FTEs which have 0 as value in EC Job info portlets.
• When the ANNUALAMOUNT is divided by FTEs with 0 values then it leads to zero division errors which in turn leads to internal server error in query of the story report or in story views intermittently.

• Navigate to the query of the story report and open the calculated column: SCALEDANNUALAMOUNT 
• There the default formula is: [ANNUALAMOUNT]/[Employment#Job Information#FTE]
  
  
  
  
• Replace the current formula with this formula:
  
  IF([Employment#Job Information#FTE]=0,0,[ANNUALAMOUNT]/[Employment#Job Information#FTE])
  
  and click on Format to validate the formula
  
  
  
  
• After that save the story report query

The formula suggested above is to avoid the zero division errors in the story reports. It will first detect the FTEs with 0 value through the IF function's conditional statement and then replace the SCALEDANNUALAMOUNT with zero. Else it will go on dividing the SCALED ANNUAL amount with non-zero FTE values.

• 3415715 - How to find available formula functions for Calculated Columns in Story Report - SAP for Me
• Formula Functions in Calculated Columns for Story Reports | SAP Help Portal
• 2960782 - People Analytics - Implementing Standard Story Templates - SAP for Me

compensation standard story reports, compensation reports, standard story reports, story report, SAP SuccessFactors story reports standard story reports, Internal error occurred while processing, Compensation story report, Story report error, SAC story report, Compensation standard story, Story reporting error, Report processing error, Story execution failure, SAP SuccessFactors Platform, Analytics processing issue, Query Designer Service, SF Compensation reports, Story rendering issue , KBA , ss_anonymizedkba , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem