Page 1 of 1

Crosstab Report: Wrong Results

Posted: Thu Jul 21, 2022 8:07 pm
by mpol_ch

Hi
I am using the crosstab reporting and facing wrong summary data.
When I use a second field in value then the ressults are correct.
But the result for the first field are always wrong.
When I change the sequence of field values then then then again the first field value get the wrong summary.
Please see the section below and compare 705 with 1000.
Both of them should be 1000.
The calculation bases on the same table...

 d (Anzahl)
 GNr (Anzahl)
 Prio
 VS
 Filter
 GS
 Filter
 KA
 Eilig
 Normal
 Vorzug
 Id (Anzahl)
 GNr (Anzahl)
 AM	RF	KA	
 15
 0
 1
 1
 0
 0
 16
 1
 MOS	BIE	KA	
 4
 1
 0
 0
 0
 0
 4
 1
 RN	SC	AF	
 21
 316
 347
 347
 337
 337
 705
 1000
 Gesamtsumme	
 348
 348
 337
 337
 317
 317
 1002
 1002

mpol_ch


Re: Crosstab Report: Wrong Results

Posted: Thu Aug 04, 2022 8:47 pm
by mpol_ch

Hi,
I have created a view with reduced fields and run the reports on the created view.
Now it is working properly.

Thanks
mpol_ch