Use an IF statement to insert formula?

auream00

Is it possible to use an IF statement to insert the correct formula? Based on the hierarchy, I need one formula added for the parent rows but a different formula for the child rows. The individual formulas do work, but not in the IF statement. Wondering if there is a trick that I'm missing?

=IF(Hierarchy@row = 0, "=SUM(CHILDREN())", "=SUMIFS({LbrTrkCost}, {LbrTrkPrj}, Project@row, {LbrTblResource}, Resource@row, {LbrTblType}, "CapEx")")

Adam Murphy

=IF(Hierarchy@row = 0, SUM(CHILDREN()), SUMIFS({LbrTrkCost}, {LbrTrkPrj}, Project@row, {LbrTblResource}, Resource@row, {LbrTblType}, "CapEx"))

auream00

I should have prefaced that I have tried this with and without quotes. Quotes give the "Unparseable" error; without quotes, gives the "Invalid Operation" error.