HOW TO SUMMARIZE SERIAL CONTINUITY AS PER DIFFERENT BRANCH

[nevilledhamsiri]

Dear Friends

How to show 1st & last number something like below when expanded serial is presented?

Thanks

Neville

BRANCH       SERIEAL

RA                    112545-112554

EH                    112555-112563

[sunny_talwar]

Is this what you want?

[nevilledhamsiri]

Yes

Could you please send me the expression/script which resulted in the expected output. I cannot open up the qvd

Thanks

[nevilledhamsiri]

Please look in to this.

Thanks

Neville

[nevilledhamsiri]

In the case two serials are continuing for THE same Branch, that too should reflect in the respective Branch. Eg As per Branch RA it has two serials. Once this is done the final results should be like below

RA                   112545-112554     10

RA                   115450-115455      6

EH                  112555-112563      9   

Please refer this data set & recommend me a easy solution. You may send me the formula that should be written to achieve this. QVW cannot be opened up.

Regards

Neville

[Kushal_Chawda]

@nevilledhamsiri  how do you identify  two serial for RA.. serials are same for both FROM and TO

[nevilledhamsiri]

Since two serials are applicable for RA00, Can it be shown under two rows such as how I have shown. Because one serial goes from 112545-112554   & other serial from 115450-115455 . 

[nevilledhamsiri]

If I cannot have two different serials for RA, the voucher allocation count for RA cannot be properly made. Because if we get the difference of 112545-115455, the answer is not correct. but it should be the difference of (112545-112554) & (115450-115455) separately to have the exacts voucher allocations

[nevilledhamsiri]

Appreciate if this is looked in to by some one.

Thanks

Neville