Write a formula to sum another formula 1

[obryant32]

First off, I'm not a programmer, I've just kind of had this project thrown at me so please forgive me if I don't know what I'm talking about.

I'm creating a report based on our business transactions. Each transaction is supposed to generate a certain amount of revenue, which has been determined to be $2750. So, since their is no field in our database where that amount is specified, I figured the easiest thing to do was create a new formula, call it target revenue and just type 2750 in there. I then put the formula into the details field and voila! each transaction has the target revenue number next to it. The problem however, is that they want a running total of the target revenues at the bottom. I tired creating another formula, but it tells me that I can't sum that formaula? What should I do?

Thanks,
Matt

 

[lbass]

I was surprised to see that this was true. Anyway, create two formulas:

//{@target} to be placed in the details section:
whileprintingrecords;
numbervar target := target + 2750;

//{@displtarget} to be placed in the report footer:
whileprintingrecords;
numbervar target;

-LB

 

[MColeman]

If you add whilereadingrecords; as the first line of your formula, then you can create a subtotal for the formula.

 

[lbass]

That is a better solution (*).

-LB

 

[obryant32]

So simple...and yet I feel as though I've shed a fifty pound weight. Works like a charm. Thanks!
Matt

 

[MColeman]

Hey, Tek-Tips keeps me learning,

I never knew about this until I tried
helping out obryant32!