PH18530: IN REPORTING THE RESULT OF A CALCULATION RETURNS WITH AN ASTERISK CHARACTER (*)

APAR status

• Closed as fixed if next.

Error description

• When having a calculation with ([Forecast revenue] - [Revenue])
  / abs([Revenue]) then the results return with an asterisk
  character (*).
  
  The documentation described this as follow:
  
  https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com
  .ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_wrkdat_format_da
  ta.html
  
  "When you create a calculation that uses mixed currency values
  or other mixed units of measure, an asterisk character (*) might
  appear as the unit of measure. To avoid this problem, change the
  format of the column or row that contains the result of the
  calculation so that the wanted unit of measure appears."
  
  But when setting a data format on the calculation then the
  results appears with asterisk character (*) as well.
  

Local fix

• use Custom->Pattern for the Data Format (ie ##0.0%)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 12.0.2                       *
  ****************************************************************
  Please see the following documentation regarding Format Data:
  https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=report
  ing-format-data
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels