STUMPER: Pre-solved Q&A to sharpen your TBM and Apptio skills.

Solution posted in 7 days if nobody submits a correct answer.

See title for rating: [+] Easy   [++] Moderate   [+++] Challenging

Have a look at this excerpt from my fixed asset ledger:

Just now I added a new column to this table:

Is App = If(IT Resource Tower="Application" AND IT Resource Sub-Tower <>="", 1, 0)

But the new column isn't working. Instead, I see this error:

Does my column formula contain error(s), or maybe I am going about this all wrong?

Hi Christopher,

I believe it is as simple as you accidentally typing <> with nothing in between, or typing it without even needing to. I'm thinking this because in the error code it says "Was expecting one of: ... '>' '<' '=' '>=' '<='" So you may have added an extra inequality sign in front of the equal sign by accident. Which is giving an error as it thinks you want greater than AND less than or equal to blank, where you would only want to say greater than or equal to, less than or equal to, or just equal to blank.

Regards,

Oli

Good suggestions, but so far my formula still isn't working.

I tried these four variations for instance:

= If(IT Resource Tower="Application" AND IT Resource Sub-Tower >"", 1, 0)

= If(IT Resource Tower="Application" AND IT Resource Sub-Tower <"", 1, 0)

= If(IT Resource Tower="Application" AND IT Resource Sub-Tower >="", 1, 0)

= If(IT Resource Tower="Application" AND IT Resource Sub-Tower <="", 1, 0)

...but received very similar error messages as before.

you need to put braces for the column name because of the "-" sign in the column name which is also an operator.

= If(IT Resource Tower="Application" AND {IT Resource Sub-Tower} !="", 1, 0)

Aha--you're right, I had two bugs in my formula:

1. I should use != instead of <> to denote "not equal to" since this is a label-type column, not a numeric-type column.

2. I should surround the column name with curly braces { } since it contains punctuation.

Now my formula is working, thank you.