Skip to Content
0
Former Member
Apr 23, 2007 at 03:25 PM

Delete amounts of keyfigure before an execution of fox formula

44 Views

Hi,

I have a layout with a button that executes a fox formula, my problem is if the user puts data on columns of amounts, when I execute the fox formula (copy of previous snapshot) these amounts not are deleted (0) if previous amounts don’t have data in these columns.

Example:

(0calmonth is dynamical)

Previous snapshot

...............03.2007|04.2007

materialA| 10........| 0

Actual snapshot

...............03.2007|04.2007

materialA| 15........| 80

After the copy function on actual snapshot

...............03.2007|04.2007

materialA| 10........| 80

I need 80 belong to 0 after the copy.

There is some way to delete all amounts of the layout and then execute the fox formula, when the user pushes on the button.

I would appreciate your help.

regards

Victoria