Active Form showing wrong value

Post Reply
ofintm1
Posts: 17
Joined: Tue Jun 21, 2016 4:26 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Active Form showing wrong value

Post by ofintm1 »

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
User avatar
gtonkin
MVP
Posts: 1192
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

Post by gtonkin »

What does it show when you rebuild the AF with Alt+F9?
Post Reply