TM1 Forum

Hello all.

I'm finding that an IF() formula residing in the referenced cell of a DBRW() is causing AF to produce zeros. Using a hard value or even a non-IF() formula appears to work. The IF() breaks it though.

For example, I have a finLocation dimension with a child of "10001" and a parent of "All Locations". A DBRW() on my AF sheet references a cell containing the finLocation element. In that cell I have =IF( scenario="Historical", "All Locations", "10001"). This breaks the sheet, meaning that all of the DBRW()s return zeros. However, if I just type in "Historcal" to the referenced cell then I'm good to go. Likewise, typing in "10001" in to the referenced cell produces values as well. It appears to just be the IF logic doing that.

I checked this thread trying to find a similar issue ( http://forums.olapforums.com/viewtopic.php?f=3&t=4163 ) without luck. There are a few more thread about zeros on Active Forms, but nothing about this in particular.

Any thoughts?

Thanks,
Chris

Two interesting findings on this already:

1. I put the sheet on TM1 Web to see if it had the same behavior. It did, but I noticed that a cell wasn't evaluating in TM1 Web that was evaluating in Excel. It turns out it was an external reference. I fixed that, but it's only producing the expected results (i.e. data) in TM1 Web, not Excel.

2. So the second finding is that I now have a sheet that appears to work in TM1 Web, but not Excel. I haven't run across that before.

I'll search the threads here in OF...

Chris