I am hoping this fab community will be able to help stop my head from hurting this afternoon.

I am trying to replicate a report which i have managed to create in Excel  in Apptio.

I am trying to understand if Apptio can nest formulas.

I have search the community but could not find anything to help me.

=IF(AND(B52>0,C52=0),D52/$D$166,IF(AND(B52=0,C52>0.01),D52/$D$166,D52/$D$166))

If Apptio can't handled the whole line, can it handled part of the formula ?

Any help is appreciated before my head explodes 

Hi Paula,

You can definitely next IF statements in Apptio, just like in Excel. 

However, Apptio syntax is different from Excel. For example, in Excel, you use the AND() formula. But in Apptio, you would just phrase it like this:

=IF(B52 > 0 AND C52 > 0.01...)

Have you tried converting the entire formula to Apptio syntax and nesting the IF, or are you just copying and pasting the Excel formula directly?

Hi Alex,

I am trying to convert to Apptio formula, but gave the example so you knew what i am trying to get to.