Good day,

I am trying to get this formula for "Is Labor" to work and Apptio is not taking it well.  Can anyone assist?

=If({Cost Pool}IN("Internal Labor", "External Labor”),”Yes”,”No”)

We use a Lookup to the Account Mapping in ours, but you might try this?

=If(Cost Pool="Internal Labor" OR Cost Pool="External Labor","Yes","No")

Hi,

The following will work:

=If(Trim(Upper({Cost Pool})) IN Upper("INTERNAL LABOR", "EXTERNAL LABOR"),"Yes","No")

You might want to pay attention to the double quotes, the ones you use don't work (””).

Also make sure the comparison might have space characters before or after the string so use TRIM to cleanup the string.

Regards,

Robert