Calculate Volume

[upaliwije]

Hi Friends,

I have two qvd files

1 . EMP.QVD  ( Giving time consumend by staff to compltete  job)

2. TOT_VOLUME.QVD ( Volume of work unots in Nos)

I want to create a file combining two files to calculate voume handle by staff members ( Receipt Nos and Debit Note Nos from volume file should be multified by Minutes from Emp file based on SEQ )

I have tried doing this using apply map method but It does not work properly. Pls help me to do it. I have attached my QV document and two data files pls.

[sunny_talwar]

What is the expected output here? You have Multiple BCOD and NOS in your applymap.... Which one should be picked?

[upaliwije]

Expected output is as follows If there is a value in Debit Notes or Dir Receipts It should be multified by Minutes.

But my problem is all records in Tot Volume is not returned whemn apply map is used

BCOD	DEBIT_NOTES	SEQ	DIR_RECEIPTS	MINUTES	Output
VU00		7	12	0.5	6
VU00		8	12	0.5	6
VU00		11	12	1	12
AA00		7	39	0.5	19.5
AA00		8	39	0.5	19.5
AA00		11	39	1	39
AA00	22	9		0.5	11
VU00	110	9		0.5	55

[upaliwije]

Can some one pls help me to solve my issue