DSum by group

[RussG]

I have a textbox with a DSum function, but would like it to query only within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.

=DSum([MKTCAP],"QryFILTER",[MKTCAP]>100)

The text box is within the Group Footer, and I'd like it to return a
different value below each group.
Thanks!

 

[RussG]

Nevermind, found the answer on an earlier post. thx!

 

[Tom Lake]

I have a textbox with a DSum function, but would like it to query only
within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.

=DSum([MKTCAP],"QryFILTER",[MKTCAP]>100)

The text box is within the Group Footer, and I'd like it to return a
different value below each group.
Thanks!

The D in DSum stands for Domain. It will sum regardless of group.

In a group footer, you want Sum which will sum just that group.

Tom Lake

 

[RussG]

Is there a "sumif" function, or any other way to sum within a group based on
certain criteria?

I have a textbox with a DSum function, but would like it to query only
within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.

=DSum([MKTCAP],"QryFILTER",[MKTCAP]>100)

The text box is within the Group Footer, and I'd like it to return a
different value below each group.
Thanks!

The D in DSum stands for Domain. It will sum regardless of group.

In a group footer, you want Sum which will sum just that group.

Tom Lake