Skip to Content
0
Former Member
Sep 23, 2005 at 09:52 PM

Defaulting Key Figures

31 Views

Hi all,

I was wondering if anyone has ever defaulted in key figure values for a planning layout before? We've got a layout with one characteristic in the lead, one in the data columns (dynamic) and one key figure in the data column. The All Possible Characteristic Combinations is turned on, so we get all the rows pre-populated. What I'd like to do now is to be able to execute a function to fill all the key figures with a value of 1.

I tried a FOX formula that simply set the keyfigure value to 1, but it seems that the function only executes on values that are already filled in, not the 0 values.

Has any ever done this before? Any help would be much appreciated.

Thanks!

~Matt