Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Members,
As per the data below, instead writing an if statement to group the total (premium value) like 0-1000,1000-5000,5000-10000 etc, how class function be used in a separate table instead?
Thanks
Neville
BRANCH_CODE | CLASS_CODE | PRODUCT_CODE | POL_POLICY_NO | NAME | REF_NO | FROM_DATE | END_DATE | POL_SUM_INSURED | TR_DATE | TR_TYPE | CP | RS | TC | TOTAL | MARKETING_PERSON | ||||
EM00 | CH | PH | EM0015PH0001316 | MR L.L. SAMEERA DILRUK | EM0018D0043437 | 28-Jan-18 | 28-Jan-19 | 0 | 28-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001945 | MR S.K. ATHUKORALA | EM0018D0043464 | 29-Jan-18 | 29-Jan-19 | 400000 | 29-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57494 - G.H.M.D NUWAN SAMEERA | ||||
EM00 | CH | PH | EM0017PH0002217 | MRS K.O. SIRIYAWATHI | EM0018C0006680 | 28-Nov-17 | 28-Nov-18 | 0 | 29-Jan-18 | REF | -1688.45 | 0 | 0 | -1688.45 | 59658 - G.G. SAJITH BUDDHIKA | ||||
EM00 | CH | PH | EM0017PH0002215 | MR J.R.A. UVINDRA LAKMAL | EM0018C0006679 | 28-Nov-17 | 28-Nov-18 | 0 | 29-Jan-18 | REF | -1688.45 | 0 | 0 | -1688.45 | 59865 - S.J. KIRTHI MADURANGA | ||||
EM00 | CH | PH | EM0018PH0002296 | MR D.M. PRIYANGANI DISSANAYAKA | EM0018R0169945 | 29-Jan-18 | 28-Nov-18 | 400000 | 29-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 15390 - H. VIJITHA KUMARA | ||||
EM00 | CH | PH | EM0018PH0002297 | MRS K.O. SIRIYAWATHI | EM0018R0169946 | 29-Jan-18 | 28-Nov-18 | 400000 | 29-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 15390 - H. VIJITHA KUMARA | ||||
EM00 | CH | PH | EM0017PH0002218 | MRS D.M. PRIYANGANI DISANAYAKA | EM0018C0006681 | 28-Nov-17 | 28-Nov-18 | 0 | 29-Jan-18 | REF | -1688.45 | 0 | 0 | -1688.45 | 59658 - G.G. SAJITH BUDDHIKA | ||||
EM00 | CH | PH | EM0018PH0002304 | Mrs W. ANURADA | EM0018D0043506 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0017PH0001948 | MR H.J.M.D.N. BANDARA | EM0018D0043494 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0018PH0002305 | Mrs W. ANURADA | EM0018D0043507 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0018PH0002298 | MR K. MANOJ BUDDIKA | EM0018D0043469 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 59341 - M.A. SURES BANDARA | ||||
EM00 | CH | PH | EM0015PH0001520 | MR M.A.S. DUMIDU | EM0018D0043510 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0015PH0001519 | MR M.A.S. DUMIDU | EM0018D0043509 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0018PH0002300 | MR A.N. THARANGA | EM0018D0043474 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 59749 - R.S. DULANJAN RUBASINGHE | ||||
EM00 | CH | PH | EM0018PH0002301 | MR J.R.A. UVINDRA LAKMAL | EM0018D0043482 | 30-Jan-18 | 28-Nov-18 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 59865 - S.J. KIRTHI MADURANGA | ||||
EM00 | CH | PH | EM0017PH0001953 | MR M.K. RANJITH | EM0018D0043491 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0018PH0002299 | MR K. MANOJ BUDDIKA | EM0018D0043470 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 59341 - M.A. SURES BANDARA | ||||
EM00 | CH | PH | EM0016PH0001934 | MR. J.M.W RANDENIYA | EM0018D0043508 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0018PH0002302 | MR R.A.P. KUMARA | EM0018D0043486 | 30-Jan-18 | 30-Jan-19 | 400000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0018PH0002303 | MR M.K. RANJITH | EM0018D0043493 | 30-Jan-18 | 30-Jan-19 | 100000 | 30-Jan-18 | NEW | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0017PH0001956 | MR D.G.C.G. PRASANGA | EM0018D0043495 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0017PH0001955 | MR L.P.A. SANJEEWA | EM0018D0043489 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0017PH0001950 | MR T.W.K.H. KUMARA | EM0018D0043492 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0017PH0001954 | MR T.T.S. LAKMAL | EM0018D0043490 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 09203 - K.P. CHAMINDA SILVA | ||||
EM00 | CH | PH | EM0017PH0001980 | MR R.M. PREMATHILAKA | EM0018D0043414 | 30-Jan-18 | 30-Jan-19 | 0 | 30-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 15390 - H. VIJITHA KUMARA | ||||
EM00 | CH | PH | EM0016PH0001595 | MR P.K.W. RATHNAYAKE | EM0018D0043180 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 07184 - D.L.W. WICKRAMATHUNGA | ||||
EM00 | CH | PH | EM0015PH0001322 | MR. H.G.D. MAHESH KUMARA | EM0018D0043435 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001992 | MRS E.M. INDRANI | EM0018D0043307 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0016PH0001588 | MR. I.G. SAMEERA | EM0018D0043306 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0016PH0001572 | MR. K.A. JEEWAN KUMARA | EM0018D0043308 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 57861 - A.G.T. DINUSHA JAYATHILAKA | ||||
EM00 | CH | PH | EM0017PH0001985 | MR G.K.T. PRABATH KARUNARATHNE | EM0018D0043408 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001986 | MR G.K.T. PRABATH KARUNARATHNE | EM0018D0043409 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001996 | MR W.A.A. PUSHPALAL | EM0018D0043406 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001984 | MR G.K.T. PRABATH KARUNARATHNE | EM0018D0043407 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001999 | MR. T.W. PUSHPA KUMARA | EM0018D0043404 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001998 | MR. T.W. PUSHPA KUMARA | EM0018D0043405 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001990 | MR. W.L. THUSHANTHA | EM0018D0043277 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA | ||||
EM00 | CH | PH | EM0017PH0001988 | MR. K.A. NISHANTHA | EM0018D0043275 | 31-Jan-18 | 31-Jan-19 | 0 | 31-Jan-18 | REN | 1688.45 | 0 | 0 | 1688.45 | 53459 - K.G.D. PREMARATHNA |
May be this?
Replace(class(POL_SUM_INSURED, 5000),' <= x < ','-')
Seems to be not doing the classes as expected. Please see where I have gone wrong?
Thanks