topic Re: Multiple Values for Variable within Expression in App Development

Multiple Values for Variable within Expression

GrantBooth — Mon, 06 Dec 2021 01:09:59 GMT

I'm trying to use multiple values for an variable within an expression and I can't quite get the syntax right.

I have variable v.Example (obviously I am using proxies as I can't show my details)

Sum({< Category1 = {"$1"},
Category2 = {"$2"}>}
Amount)/1000))

Category1 can take the following values up, down, left, right

Category2 can take the following values peppermint, topspin, Cthulu -

I would like to be able to select more than value for each variable in my set expression so for example I would like

v.Example(down, [peppermint, Cthulu])

Can someone please help out with the correct syntax?

Cheers

anat — Mon, 06 Dec 2021 02:17:53 GMT

create variables like

var1==GetFieldSelections(Category1)

var2==GetFieldSelections(Category2)

=sum({<Category1={'$(var1)'},Category2={'$(var2)'}>}Expression1)/1000

GrantBooth — Mon, 06 Dec 2021 02:26:29 GMT

Thanks, but i'm not relying on the user to make selections, I'm trying to do it directly through an expression.