Summing Formulas in Footer

[gavinjb]

I have created a Formula which adds the values of two or more fields together, but I can find no way in Crystals 8.5 to do a sum on this formula, does anyone know of anyway how to do this.

Thanks,

Gavin,

 

[dgillz]

Right click the object, select insert summary. No formula required.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

If dgillz solution doesn't work, share what is in the formula and someone will work it out for you.

-k

 

[gavinjb]

Sorry, I didn't describe this very well I have a fomula which is ([colA] - 250) * [colb], this is displayed in the detail area of the report, what I need to do is place a total for this in the footer of the report.

Thanks,

Gavin,

 

[synapsevampire]

As dgillz suggested, place the formula in the details section, right click it and select Insert Grand Total.

Now you can delete it from the details if need be.

-k

 

[synapsevampire]

I assumed that you meant Report Footer, not page footer.

IF you want it in the page footer, what is it going to represent, a running total, or the grand total?

-k

 

[gavinjb]

I am using Crystal 8.5 and if I right click I don't have that option, I tried selecting the Fomula in the detail area and going to the Insert Menu but it is ghosted out. any ideas?

Thanks,

 

[synapsevampire]

Odd... Also, that syntax doesn't look like the formula, it doesn't have the right braces, nor the table name.

Try this formula:

If isnull({table.colA}) or isnull({table.colb})
or
{table.colA} = 0 or {table.colB} = 0
then
0
else
([colA] - 250) * [colb],
({table.colA} -250) * {table.colB}

-k

 

[Ngolem]

What are [colA] and [colB]????

You are oversimplifying and that doesn't help us solve your problem....I have a feeling these are formulas with "WhilePrintingRecords" in them

Jim Broadbent

 

[synapsevampire]

Opps, another typo (must be tired:

If isnull({table.colA}) or isnull({table.colb})
or
{table.colA} = 0 or {table.colB} = 0
then
0
else
({table.colA} -250) * {table.colB}

 

[pelajhia]

ngolem writes: '....I have a feeling these are formulas with "WhilePrintingRecords" in them'

I think I understand the basic function of using this - getting the formula to evaluate at a defined point in the processing of the report - but it sounds like there are some caveats. Is there some good place to learn about this and any other evaluation statements?
Thanks!