Calculation in Impromptu

[Swathi37]

TNum TDesc Count(TSubtype)[June-03] Count(TSubtype)[May-03] Increase/Dec %ofIncrease
----------------------------------------------------------------------------------------------------
1 Pay 158 100 58
2 Invoice 2000 1900 100
3 Returns 30 20 10


Calculations for Count(TSubtype) for june-03 and Count(TSubtype)[May-03] has calculations that says between the first day of the month and last day of the month.

But when I say

(Count(TSubtype)[June-03])-(Count(TSubtype)[May-03]) I do get the correct result but it gets repeated for all the Tsubtypes (i.e the total records for that particular month is 2000) so the Increase/Dec difference shows up 2000 times for TNumber 1,2,3. How can this calculation be done without repeating so many times. Same for %ofIncrease.

Please let me know
Your help is appreciated.


The data is something like this

TNumber TDescription TSubtype
--------------------------------
1 Pay 34
1 Pay 34
2 Invoice 34
2 Invoice 34
2 Invoice 34
2 Invoice 34
3 Returns 34
3 Returns 34
1 Pay 34

 

[nagrajm]

You probably have one or more columns (most likely TSubtype or the date) in the query definition that are not grouped. In a summary report, every column in the query definition must be grouped. Therefore remove every column that is not grouped.

Your query definition must have only these columns;

TNum (Grouped)
TDesc (Grouped)
Count(TSubtype)[June-03] (associated to TDesc)
Count(TSubtype)[May-03] (Associated to Tdesc)
Increase/Dec %ofIncrease

remove every other column.