check if the value in variable matches with the value in the data

[anushree1]

Hi,

I have a requirement wherein there is a input box which holds the value for a variable, each time a value is entered into the input box i would like to check if the entered value is present in the specific column of the data model, if there is i would like to display the sum else display NA .

So please let me know if there is a way to check whether the entered value exists in the data pool or not

[neelamsaroha157]

I am sure you are storing the input value in a variable, so you can try

Sum(If(FieldValue = vVariable ,FieldValue ))

[NickHoff]

IF(GetSelectedCount(InputboxField) = <> 0, Sum({$<FieldValue = {"=$(vVariable)"}>}Field)

[sunny_talwar · Accepted solution]

Maybe like this:

If(SubStringCount(Concat(DISTINCT '|' & FieldName & '|', ','), '|' & vVar & '|') = 0, 'NA'

Sum({<FieldName = {'$(=vVar)'}>} Value))