The Summary/running total field could not be created error message

[essental]

I am trying to create a report that will show internet usage per user per site by time block;
ie: holmese 8:00 10:00

http://www.website

11:00 13:40

http://www.site

etc etc.
I used this formula
NumberVar total := Sum ({HttpData.Duration}, {Categories.Category_Name});
NumberVar hours := truncate(total/3600);
NumberVar remains := Remainder(total, 3600);
NumberVar mins := truncate(remains/60);
NumberVar seconds := remains - (mins * 60);

Formula would not create a summary/running total field.
Can anyone help me out. Thanks in Advance.

 

[Naith]

You can't automate a running total on a formula like that. Is this a paste of the complete formula?

The output of this formula is going to be the seconds variable - is that really what you want to total up? Don't you want to concatenate all the variables to give you a time string?

Naith

 

[dgillz]

See faq 767-2300 on this topic. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[essental]

Naith;
The last part of the formula is this:
if mins < 10 and seconds < 10 then
ToText(hours,0 + &quot;h&quot; + ToText(mins,0) + &quot;m&quot; + ToText(seconds,0) + &quot;s&quot;
else if mins < 10 then
ToText(hours,0) + &quot;h&quot; + ToText(mins,0) + &quot;m&quot; + ToText(seconds,0) + &quot;s&quot;
else if seconds < 10 then
ToText(hours,0) + &quot;h&quot; + ToText(mins,0) + &quot;m&quot; + ToText(seconds,0) + &quot;s&quot;

I hope this makes it clearer.
Ed