Insert running total value into a formula

[CR4Reid]

Hello all,

Been at this for a while and can't seem to get it to work. I have a report with 3 groups: By technician, by job, then by invoice. 1 technician can have multiple jobs, and each job can have multiple invoices.

Each job will have hours posted to it by the technician as well as an apprentice. The group 1 footer should show the technician's total hours for the job as well as the total hours for the job itself (which may or may not include an apprentice hours).

I managed to run a query total the hours for the job and run another query for the total hours of the technician on the job. Great - I simply add that to group 2 footer.

I can't sum the hours at the group 1 footer - so I do a running total. Great - it works.

Now, I try to use the running total in a formula to work out a ratio and it keeps saying "a number is required here". I tried the 3 formula running total and the result is the same: "a number is required here".

I simply need the running total value to be a value. Is there a quick and dirty way to do this? Any hints are very much appreciated.

 

[HowardHammerman]

Please post the formula you are trying to create.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[CR4Reid]

The formula will be on GF1. There are 2 running totals, and 1 summed field: total hours invoiced.

The formula = sum(totalhoursinvoiced)/rtTechHours

At this point, it won't let me out of the editor and complains that "rtTechHours" is not a number.

 

[HowardHammerman]

Some things to check:

When you created the running total did you select a numeric field?
Remember currency and numbers are different.

the "sum(totalhoursinvoiced) seems to be a grand total. Is that right?



Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com

 

[CR4Reid]

Aha! I think you hit that one on the head! The field is indeed a currency field.

And yes, the "sum(totalhoursinvoiced) field is a grand total.

Thank you so much Howard!