I have a formula that works fine until I put it in another formula.  I've stared at this for hours trying to figure out what's going on, but can't figure anything out.  Here are the details:

• I have a shared array defined in the report header
• Everything else mentioned below is on the Detail level
  
• There are three other formulas the formula in question uses:
• TestA is a boolean checking data field equality
• TestB is a string manipulation of a data field based on other data fields and its own value
• TestC is a boolean checking if TestB is in the shared array
• Test (the formula in question) is a simple boolean: TestA AND TestC
• I have TestA, TestB, TestC, and Test all shown in the Detail
• As long as Test is not used in another formula, it is correct
• As soon as I put it in another formula (any formula, as far as I can tell), it becomes incorrect
• When I say 'incorrect', I mean that TestA and TestC display as True, but Test is displayed as False which it clearly should not be
• I tried doing all the logic (TestA, TestB, and TestC) in the one formula (Test) thinking that maybe it was messing something up, but that didn't help anything

I am truly stumped.  Does anyone have any ideas?

Thanks so much for your quick reply!

Perhaps I was not very clear, so sorry about that and I will say explicitly: all the formulas are at the Detail level.  Declaring the shared array is the only thing in the Report Header, and I don't change it anywhere so that should not be an issue.

I have all 4 Test formulas (TestA, TestB, TestC, Test) next to each other in the Detail section.  When Test is not referenced in any formulas, it works correctly (i.e. it's boolean TestA AND TestC).  As soon as I use Test in a formula, it always evaluates as False even though all the formulas it uses (TestA, TestB, and TestC) remain the same.

Thanks for the suggestion, but it didn't make a difference even after I did a refresh just to make sure.

If it wasn't such a complicated report that's taken me ages to get this far, I'd just start over.  As it is, I have 70+ formulas and I'm not very anxious to duplicate the results with no guarantee it will even work...  The weirdest thing about this (for me, anyway) is that the part that's not working shouldn't even be difficult!

Any other suggestions that might salvage all my work?

Have you checked that none of the values used to evaluate Test A or B etc contain nulls?

kevlray, thank you for your time and suggestions!

I just double-checked and nothing is null (all the fields I'm using are required by the database).  To be extra-sure, I went into Report Options and checked off Convert Database NULL Values to Default.

It definitely seems like somehow things aren't being evaluated in the correct order, but I can't figure out how that's happening.  It seems like putting all the formulas in different Detail sections would fix that problem, would it not?