How to restrict the cases based on the specific time

[nevilledhamsiri]

Hi Friends,

Please help me to achieve these objectives!

A. I need to separate records based on the period_from field. (Please make  a Flag in the script  to pick records which are made after 02/28/2018 (February 28th 2018).

B. As per the formula written in the script to convert  class_codes such as  CH,SA as PP simmerly  I  need to includes all other codes to  the class_code1, can it be done at once such as making all other classes to be kept as it is like that rather than including all classes in to the formula.

Thanks in advance

Neville

[neelamsaroha157]

You can use your debator field as dimension and sum(premium) as your expression in a straight table.

[nevilledhamsiri]

Dear Neelam,

If that is applied all classes become pp, I need SA, CH & PP to be designated as PP & keep all other classes as it is

Any idea on this?

[nevilledhamsiri]

IF(MATCH(CLASS_CODE,'SA','CH','PP'),'PP')AS CLASS_CODE1

CLASS_CODE

MC

FR

TC

M4

MS

CH

EN

PP

HH

M3

TT

Need to expand the above function by further including all other class  as it is. I have already redesignated SA,CH,PP as PP simarlarly I need to add all other codes to be designated as they are in the same IF Match Function.

Any idea please

Neville