Implementing % change Calculation in Cognos Report Studio

[hisxlnc]

I have a report where I am currently having City , Month and Sales(in $) calculation. I need to another '% change of Sales' calculation on the report which is defined as

% Change
= ((Current Month Sales â€" Prior Month Sales)/Prior Month Sales )* 100


Please advice how to do it.

Thanks in advance.

[wyconian]

Hi

Are you using DMR or a relational data source?

If you have DMR and have the current_month and prior_month as data items the calculation is pretty simple using a tuple comand something like

You will need to use a crosstab for this

((tuple([current_month],[sales])-tuple([prior_month],[sales]))/tuple([prior_month],[sales]))*100

If you're not using DMR you will probably need to have a couple of sub queries one with current month sales and the other with prior month sales, bring them into a crosstab and then use a similar calculation to the one above

[hisxlnc]

Hi wyconian , thanks a lot for the reply.

I am using a DMR. Can the calculation be used on a List report or does it have to be a Crosstab?

[wyconian]

Hi

I think you need to use a crosstab but I could be wrong