Active Form showing wrong value
Posted: Thu Aug 02, 2018 6:27 pm
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
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