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

Newbie, Report Studio Query Layout

Started by Lnorman, 17 May 2012 05:11:00 AM

Previous topic - Next topic

Lnorman

I have a report with quite a few calculations entered, these are fine.  The trouble I have is that I have insert a query layout calculation when the report is run, this column does not appear

in the report I have

Net Sales, MatCost, LabCost - friom these tables I need to calculate the contribution which is
[Query1].[Net Sales]-[Query1].[Mat Cost]-[Query1].[Lab Cost]

Can anyone help me please !!!!!

Should of added that I have a query calculation on the netsales

if ( [Foundation Layer].[MBG160].[CINVTYPE] in ('C','M')) then (([Foundation Layer].[MBG160].[TOTGOODVAL]/[Foundation Layer].[MBG160].[CURRATE_DES])*-1)ELSE([Foundation Layer].[MBG160].[TOTGOODVAL]/[Foundation Layer].[MBG160].[CURRATE_DES])