summing in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stephendeloach - 11 Apr 2007 15:48 GMT

I have a report that has a running sum of Total Hours and Total Money. The
problem i have run into is, 14640 hours need to be multiplied by $45 and the
rest of the hours from now on need to by multiplied by $51... How can I go
about doing this without re-creating my report?

Reply to this Message

fredg - 11 Apr 2007 18:26 GMT

> I have a report that has a running sum of Total Hours and Total Money. The
> problem i have run into is, 14640 hours need to be multiplied by $45 and the
> rest of the hours from now on need to by multiplied by $51... How can I go
> about doing this without re-creating my report?

Does this work properly?

=IIf([TotalHours]<=14640,[TotalHours]*45,(14640 * 45) +
([TotalHours]-14640) * 51)

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

stephendeloach - 11 Apr 2007 20:05 GMT

Actually, let me rephrase that... I have a list oh Hours and a list of Cost...
In the Report footer, I have Total Hours =SUM([Wildcat]) <-- Wildcat is
Hours and Total Cost = (this is where you said to put the expression).
Now how would I type the expression... =IIf([??????])....
Dont know if this makes sense. But thanks for your time..

>> I have a report that has a running sum of Total Hours and Total Money. The
>> problem i have run into is, 14640 hours need to be multiplied by $45 and the
[quoted text clipped - 5 lines]
>=IIf([TotalHours]<=14640,[TotalHours]*45,(14640 * 45) +
>([TotalHours]-14640) * 51)

Reply to this Message