Sum

[upaliwije]

Hi

In my QV document I have data in the following manner

TYPE	SEQ	Nos
CLAIM_PAY_NOS	16	10,376
COMM_ENTRIES	14	54,350
COMM_PAYMENT	17	4,737
COMM_PAYMENT	20	4,737
COMM_REVERSAL	15	3,805
CREDIT_NOTES	10	4,920
DEBIT_NOTES	9	25,689
JOURNAL_ENTRY	27	19,908
JOURNAL_ENTRY	28	19,908
NPCREDIT_NOTES	49	1,543
POLICIES	-	56,697
RECEIPTS	7	61,382
RECEIPTS	8	61,382
RECEIPTS	11	61,382
RTN_CHEQUE	48	331
SUNDRY_PAYMENT	18	8,315
SUNDRY_PAYMENT	21	8,315

I want to sum this to obtain and out put like the table below . But I am unable to do since some type are dupicated with nos Pls help me to take output report

TYPE	Nos
CLAIM_PAY_NOS	10,376
COMM_ENTRIES	54,350
COMM_PAYMENT	4,737
COMM_REVERSAL	3,805
CREDIT_NOTES	4,920
DEBIT_NOTES	25,689
JOURNAL_ENTRY	19,908
NPCREDIT_NOTES	1,543
POLICIES	56,697
RECEIPTS	61,382
RTN_CHEQUE	331

[vinieme12]

Load Distinct TYPE

min(SEQ),

min(Nos)

From YourTable

Group by TYPE;

[upaliwije]

There are  some more fields in my Document If I group it It will affect my other Calculations as well. Is there any other way to get my result without reloading data

[MindaugasBacius · Accepted solution]

Use simple table object with Nos and Type fields.

Or use pivot table and in expression use:

Sum(DISTINCT Nos)

[satheshreddy]

Hi Upali,

can you check the below Script For your Output?

Regards

Sathish

[satheshreddy]

Hi Upali,

Use straight and write the below condition. you will get the out put.

Dimension --- TYPE

Exp --- Sum(Distinct Nos)

Regards

Sathish

[vinieme12]

Sum(Distinct Nos)

Or

Avg(Nos)