Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Regarding the LookupEx(), yes you can have more than one in a table. As it is a performance-intensive calculation, Apptio recommends we have them in separate Formula steps, and away from SplitEx() or SumIf() calls.
The latter requires care, as you'll have to review any weightings you might have calculated prior to the LookupEx(), e.g.:
Original data:

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Regarding the LookupEx(), yes you can have more than one in a table. As it is a performance-intensive calculation, Apptio recommends we have them in separate Formula steps, and away from SplitEx() or SumIf() calls.
The latter requires care, as you'll have to review any weightings you might have calculated prior to the LookupEx(), e.g.:
Original data:

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!

Welcome back to Product Potpourri! 

Over the month of March, we've had some great classes with a ton of interesting questions.  I'm happy to share these as we reach our latest edition of Product Potpourri!

• Can you recognize your AWS Reserved Instances as CapEx instead of OpEx?   On a general level, most cloud infrastructure is considered as OpEx, but it could be recognized as CapEx if a company's GAAP (Generally Accepted Accounting Practices) can rationalize this, in a defensible way.  As per the latest IRS notifications only tax or accounting professionals who are properly licensed and accredited should be making this decision.  Since Apptio does not provide accounting or tax services we cannot make this determination for any of our clients. 

• Can you change the hierarchy of a report from being a child report to a parent report or vice versa? In this case, the option is to recreate another report at the appropriate hierarchy level, then copy the components from your original report and add them to a new report.

• Can I use more than one LookupEX in my formulas for a table? Only one LookupEx formula can be used per formula in a table.  Like Lookup, LookupEX returns values from another table, however, LookupEx returns values for all matches rather than just the last one. That means that if it adds a row to the table for each match it finds in a second table, so if there are multiple matches you end up getting various responses. It finds every possible combination between the two tables.

• Can you revert changes back to an earlier set Check-In Point? If you have completed multiple check-ins for a project, you can roll back to an earlier check-in version if needed. Follow these steps:
  1. Go to the Build tab at the top of the screen.
  2. Choose the Check-In History button from the menu.
  3. On the screen right-click on the cell with the date of the check-in to get a pop-up with the Rollback-to as a selection.
  4. Choose Rollback To and from there you can even choose the specific check-in you wanted to roll back to.  Please Note: We recommend talking with your Apptio Account Manager or CSM before rolling back any projects. They can tell you if there are any hidden or unknown issues that might arise.  This may be especially helpful if you are doing this for the first time.  Better safe than sorry!

 It's great to be back hosting the Product Potpourri series and I'll be looking forward to seeing all the fantastic questions that come up in our new classes.  I hope to see some of you there!