# Thread: Need 2 totals for one field to go on a group footer

1. ## Need 2 totals for one field to go on a group footer

Hi again, hopefully another question with a simple answer...

Price is successfully totaled on group footer and on report footer.

Now I need to get totals for Price < \$200.00 and Price not < \$200.00 as well, in the group footer.

I don't know where to put code to "filter?" the totals or accumulate the amounts in calculated fields?

I haven't found any documentation on the actual "flow" of Alpha 5. I've been programming for 30+ years, but in a more "structured, top-down" fashion (assembler, etc.)

thanks in advance for any information you may provide...

2. ## Re: Need 2 totals for one field to go on a group footer

I'd create two calc fields using the IF() function.

In one I'd return the price if the price is less than zero and return zero otherwise.

If(price < 200, price, 0)

Iin the other I'd return the price if the price is greater than 200, and return zero otherwise.

if(price >= 200, price, 0)

then

I'd drag them into the group footer and total them over the group.

Check the help file discussion of the IF() function to understand how it works.

-- tom

3. ## Re: Need 2 totals for one field to go on a group footer

One way is to create two new calc fields for the report....

Never mind. do what Tom said. :)

After being away for a while it might take me a while to get up to speed.

4. ## Re: Need 2 totals for one field to go on a group footer

After being away for a while it might take me a while to get up to speed.
Noticed that (being away). Finally made bail?

5. ## Re: Need 2 totals for one field to go on a group footer

:D aahh who blabbed.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•