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

Percent of Total Field

Started by Quazi11, 27 Jun 2014 11:47:13 AM

Previous topic - Next topic

Quazi11

I have a report that consists of two queries unioned together. The first query gets all the Level_GL_Codes with equal to PM and the second gets all the Level_GL_Codes equal to PS. I want to add a '% Sold' column between AmountNote and OriginationDate for each PS group. So in the image the % Sold for Southwest would be 4085820.25 / 8988634.37. I am not sure how I would do this. Do I need to create a field in the queries pre join? Any tips would be appreciated.