Forum Discussion

nirupama's avatar
nirupama
New Contributor II
3 years ago
Solved

To get sum of value present in between special character like '|'

Hello Community,

I need to get the sum of value present in between special character ‘|’. Length of input may vary, one such scenario is attached. Please suggest.
Output getting after aggregate : “NEUTSUM”: “261.02||697.13|359.22”
I need to get sum of those values.

  • marjan_karafilo's avatar
    marjan_karafilo
    3 years ago

    Hi @nirupama ,

    You can try the following expression:

    $NEUTSUM.split('|').filter(x => x != "").reduce((accum, currentValue) => accum + currentValue, 0)

    Let me know if this helps you.

    BR,
    Marjan

2 Replies