PH04599: LINEST FUNCTION NOT WORKING WITHIN TM1 WEB AND RETURNS #VALUE! IN THE CELL

APAR status

• Closed as program error.

Error description

• LINEST function within both Perspectives and PAx and works
  fine, however when the Worksheet is published onto TM1 Web or
  (in my case PAW as I am testing within Planning Analytics) the
  function does not work when xValues are an array (range more
  than one column)
  TS001529859 - Sakul Gupta (US Air Force KDSS)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Planning Analytics 2.0.8 or later release         *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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:

Modules/Macros

• Unknown
  

Fix information

• Fixed component name

  PA TM1 WEB

• Fixed component ID

  5737B03WB

Applicable component levels