DBR/DBRW formulas resulting in #VALUE! errors

[antcharwill]

.

[Paul Segal]

Try unticking the Transition formula evaluation box.

[antcharwill]

It was unticked!

[Steve Rowe]

We've found that in PAfE the dependency chain is less robust for DBRW formula than in Perspectives.

Suggest you check all references in the DBRW formula for any TM1 formula, we've seen issues with things like tabdim, dimnm and elpar giving issues.

Suggest you range value each reference until your formulas work and then try and simplify the reference that is causing the issue.

HTH

[antcharwill]

Thanks for the responses. Definitely no TM1 formulas in the references. I tried hard-coding the references into the DBR formula and it didn't make a difference.

It's working now after I basically recreated the sheet in a new blank sheet. Copied the formula, the column headings, and then typed a few country names in and copied the formula down. It returned numbers for the first few countries, so I added some more, tried again and it returned numbers, added a few more and it kept returning numbers, so I copied and pasted the list of countries from the original sheet, copied the formulas down and shift-F9ed the new sheet and the formulas all worked.

Then I went back to the original sheet which was still showing #VALUE! in all the cells, shift-F9ed and it worked. As if I had to show it how to do it on the new sheet, jog its memory.

[Mark RMBC]

One of those occasions where you swear you are going mad!

My money would have been on cell B5, out of interest how exactly was that cell formatted, the cell that held Jan-2010?

regards,

Mark

[antcharwill]

The 'dates' in row 5 are just text ('General' cell formatting) 'Jan-2010' etc.

[tomok]

Probably not related to your problem but a sheet full of DBR formulas that don't utilize a VIEW statement as part of the sheet is going to perform like unmitigated crap.

[antcharwill]

Oh?