If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need Net Total Instead of Grand Total

Started by psteffen, 18 Jan 2010 11:30:14 AM

Previous topic - Next topic

psteffen

I can do subtotals and grand totals and that is not a problem.  With financial summaries (such as income statements), you do not use a grand total at the bottom, instead you use a net total (revenues less expenses). 
Many of my reports will have four columns (and four different net totals – modified budget, YTD, encumbrances, and available balance).  In essence I need to take the sum of accounts where the account number begins with a 4 less the sum of accounts where the account number begins with a 5 (and could have other additions and subtractions in the formula for account numbers starting with a separate number). 

Any help on how to do this is greatly appreciated.
Thank you

cschnu

You will need to make an if statement for your total expression. So click on the data item that represents the total in your query and change it to something along these lines:
if ([ACCOUNT_TYPE] = '4') THEN
([SUM_YEAR_TO_DATE_ACTIVITY] * -1)
ELSE
([SUM_YEAR_TO_DATE_ACTIVITY])

psteffen