IBM Apptio

 View Only

 metric formula conditional

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 02/19/21 01:30 PM
I'm trying to create a simple (so I thought) variation on the app_dev metric to incorporate filtered conditions, similar to the following,

=if({Application Investment Objective}="Eliminate",0,App Dev_Cost+App Dev_CapEx)

That doesn't work. In fact, conditionals based on most fields in the modeled Application data don't work. Application Lifecyle, however, does.

=if({Application Lifecycle}="Retired",0,App Dev_Cost+App Dev_CapEx)

Works as expected, zeroing out app_dev funds where the record has a retired lifecycle status.

What am I missing in piecing this together?

thanks much!
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 02/23/21 12:16 PM  Best Answer
Eric,

That's interesting. I think were good on avoiding the ambiguity of {various}, but the conditional is failing definitely failing to read any corresponding value, except the one mentioned. I believe we're just going to copy the app_dev metric and tie it to the appropriate table as needed.  Thanks for the response.
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 02/19/21 05:33 PM
In my experience I have had to call out the table that I am using a field from.

=if({Application Master Data.Application Investment Objective}="Eliminate",0,App Dev_Cost+App Dev_CapEx)

I'm not sure why the Application Lifecycle one worked without having to call that out.

Please see if that resolves the issue.
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 02/23/21 08:04 AM
Kelly,
I've done that too, except in this case, we have multiple apps tables, each with distinct Application Investment Objective fields and app dev logic, so seeing one field work in context made me curious as to why the others didn't in the same context.  I suspect the answer lies in creating an entirely new set of metrics, one set per application table, and leaving the stock app_dev alone. very unfortunate.

thanks for the response.

Galen
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted 02/23/21 11:10 AM
Hi Galen - One further comment on this. When using If() logic in a table it will generally rely on the information in that table post grouping. If the field that the logic is dependent on resolves to {various} this can affect your results. So ensuring that the table is grouped by the field involved will help to improve results. If you want to perform the math pre-grouping then you would need to create a calculated metric.
#CostingStandard(CT-Foundation)

Related Content