Summary of operation result

[thebigbadwolf]

Hello! I need to summarize the operation results. e.g the difference between two values and crystal not allow me to do it.
Is there a way to do it manualy?

Thank you

 

[IanWaterman]

You need to give more info.

If you want to get the difference of two summaries use a formula

@Diff

Sum(valuefield1, groupfield) - sum(valuefield2, groupfield)

Ian

 

[thebigbadwolf]

I want to get the summary of three differences
e.g.

number1-number2=number3

I need to have sum(number3)

Thanks for your prompt answer

 

[IanWaterman]

If number 1 and 2 are sumaries then you will need to use a var.

If they are just fields creat a formula and then perform a sum summary on the formula.

For a variable

@sumDiff

whileprintingrecords;

global numbervar sumdiff;

sumdiff:=sumdiff+number1-number2;

Place this in group footer where number1 are evaluated number2 (when you know it works you can suppress formula so its invisible.

Place this in report footer
@display

whileprintingrecords;

global numbervar sumdiff;

Ian

 

[thebigbadwolf]

Thank you very much. It is working.

Can we somehow reset sumdiff at the end of the group?

 

[IanWaterman]

Yes

in group Header

@reset
whileprintingrecords;]
global numbervar sumdiff:=0;

Ian

 

[thebigbadwolf]

when I put this @reset to group header, the summary reseted on every line in the group, so I only took every time last "number3" as summary.
This is happening even if I put @reset to page or to report header

 

[thebigbadwolf]

sorry, I forgot to put @display in the report. So now it seems working.

Thank you

 

[IanWaterman]

Also if you have repeat group header on each page it will reset.

you can use

not inrepeatedgroupheader;

At satrt of reset to prevent that ocurring

Ian

 

[thebigbadwolf]

Now we have the summary working (number3). This value can be used in a graph. But when we are trying to calculate this value (e.g. number3/2) the result is not recognized in the graph. Why?

 

[thebigbadwolf]

Can we somehow make @display value can be used in a graph?