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

list Report

Started by barrysaab, 07 Jun 2011 01:13:01 PM

Previous topic - Next topic

barrysaab

I have a list report with almost 30 columns,one of which is item description,which has multiple categories.There is category called  for ex  'A' which has cost maintained and there is another category say 'B' for which there is no available cost and it shows 100%.What i required to do is all the values for category which are 100% to be replaced by 4% margin.I have dragged a data item with expression (sales-(sales*0.04) and don't want this data item to be displayed in report.I am trying to write a case statement for this but failing badly.I have writgten somewhat like this

if([item desription] ='a') then ('a')
else
('b')
Please help.Thanks
Boy! Cognos getting on to me!!!

Amruta Gandhi

Hi,
I am a little confused, the multiple categories are the Rows of the 'Item Description' Column  or are they separate columns grouped with Item Description? Where do you want to use this expression (sales-(sales*0.04) ? I guess for category B? Can you please tell the exact case statement written?  Sorry for the questions although :)

barrysaab

Thanks,Amruta.These are rows of item description and we also have columns such as YTD,QTD,MTD.and we want this calculation to be refelcted on these too,if there is no cost available for tthat particular item,else what is available cost.
Boy! Cognos getting on to me!!!