Skip to main content
kavyam0002
Brainy
Oct 7, 2022 8:49 AM UTC
Solved

Sum

here i have add A and B and show it in A+B row....[A+B row is read only]

these rows am storing in value_txt field  shown in below

so i have add the value_txt data where extensionRefId=4 and 12 and show the value in that integer field which refid=14

i had tried to write like

index(fv!item.value_txt, wherecontains(4,fv!item.extensionRedId),{})

but this did not work

can anyone help me with this 

    viraty527193
    Inspiring
    Oct 7, 2022 11:13 AM UTC

    Hi,

    You need to index your rule input variable which holds multiple values instead of fv!item

    index(ri!crappContractExtraction.value_txt, wherecontains(4,ri!crappContractExtraction.extensionRedId),{})

    Hope this helps

    2 replies

    viraty527193
    Inspiring
    Oct 7, 2022 11:13 AM UTC

    Hi,

    You need to index your rule input variable which holds multiple values instead of fv!item

    index(ri!crappContractExtraction.value_txt, wherecontains(4,ri!crappContractExtraction.extensionRedId),{})

    Hope this helps

    kavyam0002
    Brainy
    Oct 7, 2022 11:19 AM UTC

    thank you.. same logic i was trying with the fv!item