Author Message

Good day to all.

I'm trying to do something simple.

Company     Time     Dollars (Time x 200.00)

----------------------------
Totals      Hrs     Dollars    1000.00 - Dollars

I want to make a simple report that takes time x 200.00 and fills a
formula field
called dollars. This prints as a summary report, one line per company,
with Time being the summary of the time details and dollard being the
summary of time x 200.00.

example:

ABC company     2.5     500.00
DEF Company     3.0     600.00

Totals          5.5     1100.00         this field ??

OK so far.

This field ?? needs to be 1250.00 - the sime of the dollars (1100.00 in
this example).
I can't seem to get this to work. I've tried 1250.00 - dollars and I
just get a 1250.00
in the field. I know this is simple. Can anyone point me in the correct
direction?

Thanks

Alan

Tue, 19 Aug 2003 06:33:14 GMT
I think the formula you want is
sum({table.timefield}) * 200 and just put this in the report footer

But I see no reason why you can't sum the Dollars field and create a grand
total.
The dollars formula should look like
{table.timefield} * 200

Quote:
> Good day to all.

> I'm trying to do something simple.

> Company     Time     Dollars (Time x 200.00)

> ----------------------------
> Totals      Hrs     Dollars    1000.00 - Dollars

> I want to make a simple report that takes time x 200.00 and fills a
> formula field
> called dollars. This prints as a summary report, one line per company,
> with Time being the summary of the time details and dollard being the
> summary of time x 200.00.

> example:

> ABC company 2.5 500.00
> DEF Company 3.0 600.00

> Totals 5.5 1100.00 this field ??

> OK so far.

> This field ?? needs to be 1250.00 - the sime of the dollars (1100.00 in
> this example).
> I can't seem to get this to work. I've tried 1250.00 - dollars and I
> just get a 1250.00
> in the field. I know this is simple. Can anyone point me in the correct
> direction?

> Thanks

> Alan

Fri, 22 Aug 2003 06:33:06 GMT
Bruce: I'll be trying this when I return next week from holiday.
Thanks for the input. I'll post how it goes.

Alan

Quote:

> I think the formula you want is
> sum({table.timefield}) * 200 and just put this in the report footer

> But I see no reason why you can't sum the Dollars field and create a grand
> total.
> The dollars formula should look like
> {table.timefield} * 200

> > Good day to all.

> > I'm trying to do something simple.

> > Company     Time     Dollars (Time x 200.00)

> > ----------------------------
> > Totals      Hrs     Dollars    1000.00 - Dollars

> > I want to make a simple report that takes time x 200.00 and fills a
> > formula field
> > called dollars. This prints as a summary report, one line per company,
> > with Time being the summary of the time details and dollard being the
> > summary of time x 200.00.

> > example:

> > ABC company 2.5 500.00
> > DEF Company 3.0 600.00

> > Totals 5.5 1100.00 this field ??

> > OK so far.

> > This field ?? needs to be 1250.00 - the sime of the dollars (1100.00 in
> > this example).
> > I can't seem to get this to work. I've tried 1250.00 - dollars and I
> > just get a 1250.00
> > in the field. I know this is simple. Can anyone point me in the correct
> > direction?

> > Thanks

> > Alan

Sun, 24 Aug 2003 06:58:37 GMT

 Page 1 of 1 [ 3 post ]

Relevant Pages