Hi all, I'm using CR 2k8... My report outline looks something like:

Report Header
Page header a
Page header b
Group Header #1a
Group Header #1b
Details
Group Footer #1a
Group Footer #1b
Report Footer
Page Footer
----

In the details section I have two formula fields. One is an sum of two items in that same detail (Plus/Minus_, and the second is a running average of the Plus/Minus.

How can I setup a third item, that would start at 100 when the report is run, and increment based on the average field?

For example, if the average field is > 1 the third item would increase by 1, to 101..

Thanks
David

@FrnhGLI.. Thank you for that.. I have amended your forumla slightly.. But apperantly have gotten the syntax of CR incorrectly.. Can you point at what I'm goofing?

global numbervar nIncrement:=nIncrement +
(if {#RTotal0}<(-20) then -2 else 0);
(if {#RTotal0}<(-15) and {#RTotal0} > (-20) then -1.5 else 0);
(if {#RTotal0}<(-10) and {#RTotal0} > (-15) then -1 else 0);
(if {#RTotal0}<(-05) and {#RTotal0} > (-10) then -.5 else 0);
nIncrement;

-----

Thanks
David

Got it:

global numbervar nIncrement:=nIncrement +
if {#RTotal0}>(20) then -2
else if {#RTotal0}>(15) and {#RTotal0} < (20) then -1.5
else if {#RTotal0}>(10) and {#RTotal0} < (15) then -1
else if {#RTotal0}>(05) and {#RTotal0} < (10) then -.5 else 0;
nIncrement;

My last remaining question.. How can I have this formula work on the last value of #RTotal0 only?

That is it averages items in the detail. But it repeats for each record in the group. Where that formula is concerned, I'm only interested in the final value. The result..

Thanks
David

Do you still want it to display in the detail section or in the group footer?