3 Replies Latest reply: Jun 21, 2018 11:17 AM by Jeremiah Bakerstull

# Assigning Values and adding them together

Good morning all,

What I'm trying to do is assign a value to field if it's selected.

What I achieved using formula below,.

=if(Match(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Nancy''s Place'),39)

Now if I select multiple fields, I want to add two values together that I assigned but the value shows up as zero.

=if(Match(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Nancy''s Place'),39,

if(Match(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Faith on 6th'),89))

I also tried this formula (created by sunny). The formula below disregards the selections made. It just adds the values.

=RangeSum(Avg({<[Entry Exit Provider Name] *= {'LSS - FM Faith on 6th'}>} 89),

Avg({<[Entry Exit Provider Name] *= {'LSS - FM Nancy''s Place'}>} 39))

I also tried this formula but sum add up to 23,585 (?).

=Sum(If(Match([Entry Exit Provider Name],'LSS - FM Faith on 6th'),89,

If(Match([Entry Exit Provider Name],'LSS - FM Nancy''''s Place'),39,0)))

• ###### Re: Assigning Values and adding them together

Are you sure, you have these * in place?

=RangeSum(Avg({<[Entry Exit Provider Name] *= {'LSS - FM Faith on 6th'}>} 89),

Avg({<[Entry Exit Provider Name] *= {'LSS - FM Nancy''s Place'}>} 39))

You can try this

RangeSum(

if(SubStringCount(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Nancy''s Place') > 0,39),

if(SubStringCount(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Faith on 6th') > 0, 89)

)

• ###### Re: Assigning Values and adding them together

Are you sure, you have these * in place?  - Yes,

=RangeSum(Avg({<[Entry Exit Provider Name] *= {'LSS - FM Faith on 6th'}>} 89),

Avg({<[Entry Exit Provider Name] *= {'LSS - FM Nancy''s Place'}>} 39))

This formula worked:
RangeSum(

if(SubStringCount(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Nancy''s Place') > 0,39),

if(SubStringCount(GetFieldSelections([Entry Exit Provider Name]),'LSS - FM Faith on 6th') > 0, 89)

)

• ###### Re: Assigning Values and adding them together

Thank you (again for you time and help)