Skip main navigation (Press Enter).
Log in
Toggle navigation
Community
Topic Groups
Champions
Meet the Champions
Program overview
Rising Champions
IBM Champions group
User Groups
Find your User Group
Program overview
Events
TechXchange Conference
Community events
All IBM events
Participate
IBM Community Hub
Welcome Corner
Blogging Guidelines
Member directory
Community leaders
Resources
Badge Program
IBM Support Customer Day
Log in
IBM Apptio
×
Apptio
A place for Apptio product users to learn, connect, share and grow together.
#Aspera
#Apptio
#Automation
#FinOps
#Apptio
#ITAutomation
Group Home
Threads
7.7K
Blogs
84
Upcoming Events
0
Library
688
Members
1.9K
Β View Only
Share
Share on LinkedIn
Share on X
Share on Facebook
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
#REF! error in OPEX Total for new forecast
Apptio Community Member
12/27/21 05:05 PM
Hi, I'm currently seeing a #REF! error in the OPEX Total metric in the Summary Tab of Expenses in IT ...
Guillermo Cuadrado
12/28/21 08:11 AM
It sure looks like an Excel error, @Andre Largie. Maybe something you uploaded? Unfortunately, I ...
Hee Sung Kang
12/28/21 11:40 AM
Has anyone in your team/org updated the reference data in ITP recently? That's the main reason I can ...
1.
#REF! error in OPEX Total for new forecast
Like
Apptio Community Member
Posted 12/27/21 05:05 PM
|
view attached
Reply
Options Dropdown
Hi,
I'm currently seeing a
#REF! error in the OPEX Total metric in the Summary Tab of Expenses in IT Planning after opening a new forecast for next year (Jan 2022). Has anyone else received this error before? If so, what could be the cause?
Thanks
#ApptioPlanning(ITP/ITFMF)
2.
RE: #REF! error in OPEX Total for new forecast
Like
Guillermo Cuadrado
Posted 12/28/21 08:11 AM
Reply
Options Dropdown
It sure looks like an Excel error, @Andre Largie. Maybe something you uploaded?
Unfortunately, I don't know enough about ITP to be of any more help.
Happy holidays! πππββ
3.
RE: #REF! error in OPEX Total for new forecast
Like
Hee Sung Kang
Posted 12/28/21 11:40 AM
Reply
Options Dropdown
Has anyone in your team/org updated the reference data in ITP recently?
That's the main reason I can think of seeing the error you are getting.
Basically some update in reference data isn't matching your forecast data
Γ
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Related Content
#REF! error in OPEX Total for new forecast
Apptio Community Member
Added 12/27/21
Library Entry
Re: Loading Forecasts
Apptio Community Member
Added 07/18/18
Library Entry
Forecast direct costs (Outdated; click for updated version)
Apptio Community Member
Added 03/21/17
Library Entry
Apptio Tips & Tricks: IIP Integrated Planning - Apptio One
Varad Rajeev Muthal
Added 03/28/24
Library Entry
Forecast indirect service costs (Outdated; click for updated version)
Apptio Community Member
Added 03/21/17
Library Entry
Copyright Γ―ΒΏΒ½ 2026 IBM Community. All rights reserved.
Powered by Higher Logic