sum using a running total without getting suppressed values 2

[DJWheezyWeez]

First off, I'm using CR XI.

I'm not sure suppressed is the right word but I'll explain. In my report, I'm using {table.job}, {table.price}, and {table.date}. Sometimes there is two or more prices per job but I only want to use the price from the newest date. For that I use the following formula in Section Expert>Details>Suppress [x-2]:

{table.date} = maximum({table.date}, {table.job})

The problem is when I want to get subtotals or grand totals, I can't seem to get a sum without getting the values on the older dates as well. I've tried using the normal summing function and running totals but I have trouble and the running totals sometimes. I think I need to evaluate it by some formula but I don't know.

Any thoughts?

-DJWW

 

[DJWheezyWeez]

I'm still working on the same report and realized that {table.date} = maximum({table.date}, {table.job}) isn't doing what I thought it did. I moved that formula to the Group Selection formula area and it's sorta doing what I need it to do... I'll get some verification here for what the report needs to do and I'll probably be back for help.

For now, disregard this thread.

-DJWW

 

[Madawc]

You probably need a running total controlled by a formula. The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Yes, you should be using group selection and then the running total should calculate only based on what is displayed in the report.

-LB