How to Query and Accumulate a list from Split string?

(0) Share

Report

Posted on by John_Martel

Hello,

I have the following string "A100,A101,A102". What I am trying to do is to split the comma separated string, lookup value on the list (sample below) based on the MatID and accumulate the values into one variable (60 in this example).

So I thought of the following, but that didnt work because editor said i cant use Set inside ForAll. Any ideas? Thanks!

ForAll(Split("A100,A101,A102", ","), Set(myAccumulator, myAccumulator + LookUp(myList, matID=Result, MatValue))

MatID	MatValue
A100	10
A101	20
B100	30
C100	50
A102	30

Categories:

Connecting to Data

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

John_Martel 38 on at

Like (0)

Report
Re: How to Query and Accumulate a list from Split string?

It turns out it's as simple as adding the Sum function 🙂

Sum(ForAll(Split("A100,A101,A102", ","), LookUp(myList, matID=Result, MatValue)), Value)

Was this reply helpful? Yes No