AX2224

Defining default values for current value

Axiom Software has two ways to return the current value during multipass processing: the file processing variable [Current_Value], and the function GetCurrentValue.

During multipass processing, these features return information relating to the current item being processed. For example, if processing by region, they would return "North" when North is the region being processed.

You may want to process the same report using "standard," non-multipass file processing. In this case, you must decide what you want the current value to return when not using multipass processing.

On the File Processing Control Sheet, you can define a default value to use when using non-multipass processing. For example, if your multipass setting is DEPT.VP, you can define a default value that is something like "Consolidated" or "All VPs". When you process the file using multipass processing, the current value will return the VP name. When you process the file using non-multipass processing, the current value will return "All VPs". This way you can use the same settings for both processing contexts.

If you do not define a default value, then the current value will return nothing (blank) during non-multipass processing. This may be the desired effect. However, if you have set up file names or other settings using constructions such as "[Current_Value]_IncomeStatement," then you should define a default value, otherwise you will get the following when non-multipass processing: "_IncomeStatement". (This may not matter if the file is only for use with multipass processing.)

To define a default value for the current value:

1. In the file, go to the File Processing Control Sheet (Control_FileProcessing).

   You must use the control sheet to set default values. The task pane does not contain settings for this feature.

2. At the top of the control sheet, under Source Columns and their Current Value defaults, locate the source column for which you want to define a default value.

   If you used "basic mode" to set up the multipass settings, this area lists only one column: the column you selected as the source column. If you used advanced mode settings, then this area may list multiple columns. Each column listed here can have a corresponding default value.

3. In the cell directly underneath the source column, type the value that you want to use as the default value.