topic Parametrized Variable Problem in App Development

Parametrized Variable Problem

brunolovatti — Wed, 15 Aug 2018 12:46:37 GMT

Hi!

I've created some varibles that works like functions.

Example:

variable fVerbaSup

(

sum(

{

$<[Comprador]={$1},[Modalidade]={'SUPERMERCADO'}>

}

[Valor Verba]

)

Where $1 is the parameter.

I use it with success like:

$(fVerbaSup( "888 |*"))

But I could not pass more then one Comprador in the same parameter, like:

$(fVerbaSup( "888 |*", "304 |*" ))

It does not work and returns the sum of Valor Verba from Comprador 888 only.

Strange is the fact that if I do not create a variable and use the sum directly in the object, it works, like:

(

sum(

{

$<[Comprador]={"888 |*", "304 |*" },[Modalidade]={'SUPERMERCADO'}>

}

[Valor Verba]

)

Anybody has a suggestion on how I could pass more then one Comprador in the SAME PARAMETER?

I tried a lot of combinations without success.

$(fVerbaSup( "888 |*", "304 |*" ))

It must be in the same parameter because I have many others functions that will receive 1, 2, 3 or N Comprador.

Thank you!

Re: Parametrized Variable Problem

rwunderlich — Wed, 15 Aug 2018 18:19:09 GMT

You cannot use a comma as part of the parameter value. Even though it is in quotes, the comma will be treated as a parameter separator and 304 will be assigned to $2.

The only workaround I've found is to use a proxy character for the comma and do a replace in the expression. Something like:

$<[Comprador]={$(=replace('$1','@',',')},[Modalidade]={'SUPERMERCADO'}>

and

$(fVerbaSup( "888 |*"@ "304 |*" ))

-Rob

Re: Parametrized Variable Problem

brunolovatti — Wed, 15 Aug 2018 18:59:16 GMT

Did not work.

I'm doing more tests.

It worked now. Your code was missing another ) character.

(

sum(

{

$<[Comprador]={ $(=replace('$1', '@', ',')) },[Modalidade]={'SUPERMERCADO'}>

}

[Valor Verba]

)

Thank you very much!!

Re: Parametrized Variable Problem

rwunderlich — Wed, 15 Aug 2018 19:38:12 GMT

"It worked now. Your code was missing another ) character."

That's why I said "Something like"

Glad you got it working!

-Rob

Re: Parametrized Variable Problem

marcus_sommer — Thu, 16 Aug 2018 05:43:56 GMT

If it's just multiple (selections) values you could use a different syntax to avoid the comma-issue. Try it with:

$(fVerbaSup(("888 |*"|"304 |*")))

- Marcus