Apptio for All

 View Only

 Formulas Error

Jump to  Best Answer
  • ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted 01/27/22 01:01 AM
Hello. I have accidentally deleted the default formulas and the table itself in Labor Master Data.

And based on the following support I did roll back (Luckily found history).
https://community.apptio.com/communities/community-home/digestviewer/view-question?ContributedContentKey=b0750fb4-c7e8-4ca6-954f-4eec86bca6cc&CommunityKey=33d98181-546b-4d6f-8607-b54ea3dc4de3&tab=digestviewer

As a result, the Labor Master Data table was restored, but the Formulas definitions were not.

The following two errors occurs while I am trying to restore it manually.

Key Metafield = Eval(Key Metafield Instruction)
Error: Cannot find column named "null" in table "Labor Master Data".

Key Metafield Instruction = TableMatch(Key Metafield Inputs, Key Metafield Equation)
Error: Cannot find table named "Key Metafield Inputs"

What steps can I take to recover from these errors?
#ApptioforAll
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 01/28/22 09:53 AM  Best Answer
Hello @Kyoichi Osada. I understand that from the Key Metafield Inputs table, you're trying to extract the Key Metafield Equation column (2nd formula on your list). Then you're trying to execute that formula with the Eval() formula in the 1st​ one.
 
The engine is telling you it cannot find the Key Metafield Inputs table, thus it returns a null value. This in turn, triggers the error in the first column, as there is nothing to evaluate.
 
It would seem that the table you're trying to use for the TableMatch() call got deleted. I guess you'd have to re-create it.
#ApptioforAll

Related Content