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

Percentage Variance in List Row Summary

Started by AnuElza, 21 Sep 2018 03:43:10 PM

Previous topic - Next topic

AnuElza

Hi,

I have a report query which is a "union" of say query1 and query2.
Query1:
Year      Qty
2017     50

Query 2:
Year    Qty
2018    70

Report: List shows data like this;

Year   Qty
2017   50
2018    70
% diff   40%  -->(70-50)/50*100
now, How can I show a list summary as a percentage variance of qty? Is it even possible to show?

Appreciate your time.

Thanks.