Platform

 View Only

 Last Month YTD

Jump to  Best Answer
  • ApptioBI
Dawn Kassube's profile image
Dawn Kassube posted 06/21/22 12:41 PM
Is there a Last Month YTD Metric as Current Date is not correct for our Financial Users who are analyzing the prior month financials.  We attempted to create a Calculated Metric but received a "Datasource not available Error.


#ApptioBI
Rene Norskov's profile image
Rene Norskov posted 06/28/22 05:55 AM  Best Answer
@Dawn Kassube  A couple of things to check:  Make sure that the OpEx Budget metric is available on it own - i.e. add it as a normal - non-calculated metric.  Also make sure that your project has been promoted in TBM Studio.  Otherwise you should raise a support ticket.​
#ApptioBI
Rene Norskov's profile image
Rene Norskov posted 06/21/22 05:40 PM
@Dawn Kassube  I experience the same error message when I attempt to create the calculated metric.
@Vandana Prasad Are you able to assist with this question?​
#ApptioBI
Dennis Kroer's profile image
Dennis Kroer posted 06/22/22 03:12 AM
Hey Dawn,
You need to ensure that the "Date Range" is "This Month" for the widget (not on the calculated metric) - then that calculation will deliver a result. If you choose "This Year" it will not.
I have just tested with a Cost Center listing, and listed "OpEx Budget" and "LM YTD" as per definition in your screenshot.
#ApptioBI

Related Content