RE: Three Formula Approach

[allyne]

Hi EveryOne,

Im using the three formula approach as follows:

In the group header :
Formula Name "ResetsCountTo0" with the following formula
WhilePrintingRecords;
NumberVar BidRecNum2:= 0

Formula Name "BidRecNum2"
WhilePrintingRecords;
NumberVar BidRecNum2:= BidRecNum2 + 1

In the Details Section:

Formula Name "BidRecNum2"
WhilePrintingRecords;
NumberVar BidRecNum2:= BidRecNum2 + 1

Formula Name "IncrementCount"
WhilePrintingRecords ;
NumberVar First35;
NumberVar First36;

If {@BidRecNum2} < 37
THEN
(First35:=+{tblInCollectBySidMarket1.30};
First36:=+{tblInCollectBySidMarket1.60})
Else
(First35:=+0+
First36:=+0)

;ToText(First35) + ' '+ ' ' + ToText(First36)

So far this works great but

In the Group Footer

I want to pull out the total of First 35 In one formula and then First 36 In another formula

So far I have:
FormulaName &quot;Total30&quot;
WhilePrintingRecords ;
NumberVar First35

But come up with 0

I this possible to have two or more variables (as I will have more variables to add) in the 3 formula approach and the get a total. If so can you show me the correct syntax.

Thanks for all your help in advance!

 

[allyne]

OOPPSSS!!! I got It !

Thanks for your help and time.