MAX ISSUE

[#1]

I have a data which includes Policynum and Module. When the policy renewes it is assigned a new mod .

for example Policynum '123456' CAN HAVE MODULES 01,02,03 and 04

I am trying to pick the latest combination of policy and module

so  for above policynum I wanna see only Policynm'123456' and module '04'.

How can I do that

[#2]

They are available in a string and not as seperate field values

[Mark_Little]

Hi,

That explains the problems.

Will need to brake it down down

maybe something like

SUBFIELD(Module,',', LEN(KEEPCHAR(Module,','))

Mark

[#4]

Do u have an email I can email you the screen shot cuz cant  attach on reply screen

[#5]

What do u mean break down?

[hemhund2016]

Hi Rehan,

If they are in string, then use it as below.

Assuming Module is as  '01, 02, 03, 04'

Dimension:   Policynum

Expression : SubField( Module,',',-1)

Thanks,

Hemanth.

[nico_ilog]

What does the source data look like?

N

[#8]

[#9]

Did you get a chance to look at the screen shots I sent you

[sunny_talwar]

Try this:

Max(TOTAL <Policynum> module)

[#11]

TRy this in Expression?