Dear experts,
I have a general active form budget template with a field to enter a margin. The margin is then multiplied by a volume to generate an income figure.
If the margin is say 3% and I type in 10% on top of the DBRW formula and then recalculate with shift f9 or f9 the margin changes back from 10% to 3%. Despite this it shows 10% when looking in the cube viewer immediately after entering it.
Is this expected behaviour? The only way the DBRW brings back the new 10% margin is if I rebuild the active form, which is a lot slower than a recalc. It is as if 3% is the cached value until a rebuild?
Thanks
Oli
Active Form showing wrong value
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Active Form showing wrong value
What does it show when you rebuild the AF with Alt+F9?