Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

When an accumulated function is created it is given a name:

image description

This example has one with a name of AccumulatuionCostJob ID

You can use the VALUE of that field for manipulation. Result:

image description

Hello,

When an accumulated function is created used in a Text Box, internally it is given a name:

image description

This example has one with a name of AccumulatuionCostJob ID in a text box named formatted field.

You can use the VALUE of that field for manipulation. Result:

image description

Hello,

When an accumulated function is used in a Text Box, internally it is given a name:

image description

This example has one with a name of AccumulatuionCostJob ID in a text box named formatted fieldCostTotal.

You can use the VALUE of that field for manipulation. Result:

image description

Hello,

When an accumulated function is used in a Text Box, internally it is given a name:

image description

This example has one with a name of AccumulatuionCostJob ID in a text box named CostTotal.

You can use the VALUE of that field for manipulation. Result:

image description

Another use of the accumulated figure. This time applied to the detail:

image description

You can open image in a different tab for a better view.

Hello,

When an accumulated function is used in a Text Box, internally it is given a name:

image description

This example has one with a name of AccumulatuionCostJob ID in a text box named CostTotal.

You can use the VALUE of that field for manipulation. Result:

image description

Another use of the accumulated figure. This time applied to the detail:

image description

You can open image in a different tab for a better view.

Field (CostTotal) containing accumulation set up used above:

image description

Hello,

When an accumulated function is used in a Text Box, internally it is given a name:

image description

This example has one with a name of AccumulatuionCostJob ID in a text box named CostTotal.

You can use the VALUE of that field for manipulation. Result:

image description

Another use of the accumulated figure. This time applied to the detail:

image description

You can open image in a different tab for a better view.

Field (CostTotal) containing accumulation set up used above:

image description

Edit 1/22/2018:

Slightly different but same area. This is for Running Totals. Added Function to 'Job ID' header:

image description

Defined as:

image description

Then the text field in detail line: VALUE([CounterJob ID]) (entered in 'Data field').

Produces this report:

image description

Value resets upon a new "Job ID" so each invoice has running total.

Thought this may interest you.