Does Apptio have a function similar to the And function in Excel?

Hello Michael,

If you look at Apptio's Function list, there isn't a specific AND function however, you can use AND like you can in excel formulas.   For example,  if I wanted to check the value in two columns and I only wanted to return a specific value if BOTH are true I can use AND in my formula.  Here is an example:

=If(Expense Type="OpEx" AND Fixed Variable="Fixed",Amount,0)

In this example, Apptio checks the values in both the Expense Type and Fixed Variable Columns, and only if both are true will it return the value in the Amount column.  For all other cases it will return the "false" value which in this formula is "0"

Hello Michael, 

If you say "similar to the And function in Excel" - yes, the above usage mentioned by Debbie should be helpful.

When we look at another possible usage of AND in addition to the above, the first thing that strikes my mind is the "Filter" step in Transform pipeline.

We have used AND in Filter step a lot! 

More details on Filtering Data can be found here: Filter data