Grand Total on Formula

[hbarbs]

I am trying to grand total on a forumla, and it is not allowing me to do so (as you can see I am very new to Crystal).

The forumla is in my group and is
Sum ({CnGf_1.CnGf_1_Amount}, {CnAttrCat_1.CnAttrCat_1_Description})-Sum ({CnSmryGft_1.CnSmryGft_1_Total_Gift_amount}, {CnAttrCat_1.CnAttrCat_1_Description})

Is there any way to run a total on all my entries for this field?

Thanks a bunch!

 

[synapsevampire]

Use a formula, as in:

whileprintingrecords;
numbervar MyTotal:=
MyTotal+Sum ({CnGf_1.CnGf_1_Amount}, {CnAttrCat_1.CnAttrCat_1_Description})-Sum ({CnSmryGft_1.CnSmryGft_1_Total_Gift_amount}, {CnAttrCat_1.CnAttrCat_1_Description})

Now display the formula in the report footer using:

whileprintingrecords;
numbervar MyTotal

-k

 

[NRobertson]

Formula,

Sum (fld, condFld)

Because you're putting in a condition field it's only going to summarise by grouping that field. If you take that out of your grand total formula it should summarise correctly

Sum ({CnGf_1.CnGf_1_Amount}) - Sum ({CnSmryGft_1.CnSmryGft_1_Total_Gift_amount})