Pass multiple Input Box values into Expression

[#1]

Hi, I have an input box where users enter a value and I pass the value into an expression in many charts.  Can I have the user input multiple values into the input box and pass the multiple values into my expression?   Here's what I have now.

sum({$<FORECASTID={"$(INPUTBOXVALUE)"}, LevelName = { 'Assets' }>}AvgBal

[chematos · Accepted solution]

Hi,

have you tried to write that values into the inpunt box separated by commas??

if sum({$<FORECASTID={"$(INPUTBOXVALUE)"}, LevelName = { 'Assets' }>}AvgBal          is not working, you could try this:

sum({$<FORECASTID={'=$(=Subfiled($(INPUTBOXVALUE),','))}, LevelName = { 'Assets' }>}AvgBal

hope this helps.

Regards,

Chema

[#3]

no luck with that one…. I wish I could put an “in” in my set analysis line. Jim

[chematos]

Sorry, function subfield needs the number of each field in the list .... good luck

[#5]

Thanks for the effort, actually you’ve given me an idea to go in a different direction. Jim

[#6]

Hi jfrancisco,

How did you get on?

Thanks

Al

[#7]

Hi jfrancisco,

How did you get on?

Thanks

Al