comparing list items and changing value

tejaswini
Contributor

comparing list items and changing value

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:

 valueTypeStatusChange value
A1145TypeAActive 
A2124TypeAInactive145
B1173TypeBActive 
C1122TypeCActive 
1 REPLY 1
KirillKuznetsov
Certified Master Anaplanner

Re: comparing list items and changing value

Hi @tejaswini 

Here is my solution

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

KirillKuznetsov_0-1639673873424.png

 

KirillKuznetsov_1-1639673876910.png

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