Hi,
I made a formula fields where I put a multiplication of two formulas fields:
exemple:
if {@qtedeclarees}<>0 then {@qtedeclarees}*{@custa}
else 00;

@qtedeclarees and @custa are the two formulas.

Now I wanted to make a sum formula in this field, but when i insert Summary the formula fields not appear on the "Choose a field to summarize"

someone can help me please?

since the formula is not performed all the time, it cannot be summarized. CR uses several passes through the data, and summarization is before the report is rendered. The formula is evaluated at the time the report is rendered...so it is too late to be summarized.

You can use Running Totals or Variables to keep track of the sum as a work around.

HTH

Hi, thanks for the help. but... how do I use Shared variables?

One more times thanks

What Sastry has provided is a basic shared variable.
Usually shared variables come in groups of 3 formulas: reset, increment, and display. Sastry has given the increment and the display.

reset is pretty basic:
Numbervar x := 0;
"" //will hide zero on the report

for reference,
reset is typically in a group header
increment is in details
and display is in group footer

HTH

Edited by lockwelle - 25 Oct 2013 at 6:56am