comparing list items and changing value

tejaswini
tejaswini
in Modeling

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 
Tagged:

Best Answer

  • KirillKuznetsov
    KirillKuznetsov
    Answer ✓

    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

     

     

Categories