how to- get total only at section heading level?

[ravina]

Hi,

I do not seem to find out.. how to total only at section heading level? it I press total button for any column... it gives me total at each grouping levels?

-ravina

 

[mfgf]

Drop a calculation into the section heading. The expression for the calculation would be:
total([whatever_your_numeric_item_is] for [whatever_your_section_heading_is_based_on])

Obviously, substitute the appropriate item names from your report in place of the data item names I have used.

Regards,

MF.

 

[ravina]

will try and let you know.. thanks.

 

[nmbcognos]

I have a similar problem.
I created a calculated column to show the total for a simple calculation but to include only certain condition.
I get an error when I use the following code:
total([TRL_PRICE]*[TRL_QTY] for [PAR_COMMODITY] = 'FLD')

I just cannot see what is wrong with it.

Peter

 

[mfgf]

Is this a calculation or a filter?

The syntax you have included would be valid for a filter, but not for a calculation.

You could break it up like this - the calculation would be:
total([TRL_PRICE]*[TRL_QTY] for [PAR_COMMODITY])
and the filter would be:
[PAR_COMMODITY] = 'FLD'

Or alternatively, if you didn't want to filter as above but just wanted to see the total for the FLD rows, you could create a calculation [COMMODITYTOTAL] using:

if ([PAR_COMMODITY] = 'FLD') then ([TRL_PRICE]*[TRL_QTY]) else (0)

and then use this in another calculation:

total([COMMODITYTOTAL] for [PAR_COMMODITY])

Regards,

MF.