comparing list items and changing value

tejaswini

Hi,

 

In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value

if two list items has same type and status as inactive then change value for inactive list item should get active list item value

EX:

	value	Type	Status	Change value
A1	145	TypeA	Active
A2	124	TypeA	Inactive	145
B1	173	TypeB	Active
C1	122	TypeC	Active

KirillKuznetsov

Hi @tejaswini 

Here is my solution

It does not consider that two or more list items with the same type will be both active.

 

You can try to use firstnonblank function and additional module dimentioned by Types list to improve the approach a bit.

Cheers,

Kirill Kuznetsov

 

Advanced Consultancy