wrong running total

[codrutza]

Hi
CR XI
Maybe you can help me with this:

I have a group by company

In details I have a formula
@date1:
if {table.Status}="Prospect" then
(if month({table.Date})=1 then 1)

in groupfooter1 I put a running total sum @date1; evaluate on change of field name; reset onchange of group company

When I run the report, is giving me with one less, (so instead of 14, it gives 13).

What do I do wrong?

 

[IanWaterman]

Why use a Running total. Try a normal sum summary of your formula.

Ian

 

[codrutza]

Hi Ian, thanks for reply. Because each name (with the date) appears few times.

 

[pmax9999]

Hi codrutza

Can you provide some sample data, showing the result you are getting amd the results you expect.

Cheers
Pete

 

[IanWaterman]

Place your RT in details and see how it changes with each record.

If you can not get it to count first or last record consistently you can use a formula to display final count

@mth1Count
{#sum @date1} +1

Ian

 

[Madawc]

Or use Crystal's automatic totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[codrutza]

Thank you all for your replies.
I put the running total in details, like you said Ian.
Now I put the code instead of the name. They were 2 with the same name and different code.

 

[IanWaterman]

Sorry not sure what you mean.

Try renaming one if you have a clash.

Running totals have this name convention
{#RunningTot}

Formula look like

{@formula}

Ian

 

[codrutza]

Sorry, my English..I meant that the issue is sorted now