topic Re: expression in set-analysis as variable in App Development

expression in set-analysis as variable

Costa — Wed, 30 Jun 2021 13:15:58 GMT

Hey there,

I have a set analyis looking like below.

sum ( { $<[Positionsnummer]={'12345678'},[Währungstyp]={'30'},Kalendermonat={'12'},Kalenderjahr={'$(vCurrentKalenderjahr-1)'},Version={'100'},Werttyp={'Ist'}> } Kennzahl)

The red marked text is kind of flexible and can occur in like 60 different versions, which i regularly need to change.

I wanted to pre-define the flexible part with a variable and put only the variable in the set analysis afterwards.

So i have created a variable = [vSet1] in the variable editor

$<[Währungstyp]={'30'},Kalendermonat={'12'},Kalenderjahr={'$(vCurrentKalenderjahr-1)'},Version={'100'},Werttyp={'Ist'}>

Now, I want to put the variable into the set analyis, to give me same result as with the set-analysis from the beginning.

sum ( { $<[Positionsnummer]={'12345678'}> + $(vSet1) } Kennzahl)

Unfortunatly, the result somehow is just different. It looks like it ignores the expression from the variable.

What am I doing wrong?

Best:)

Re: expression in set-analysis as variable

Mark_Winter — Wed, 30 Jun 2021 14:02:39 GMT

Hi Costa,

Here's my working expression

Sum({<Dim1={'A'},$(vSet1)>}Expression1)

And my working variable vSet1 it needs to use

Dim2={'b'}

Using this or having the whole expression not using variables gives me the expected same results.

Re: expression in set-analysis as variable

Costa — Wed, 30 Jun 2021 14:03:37 GMT

works perfectly fine - thanks Mark 🙂

Re: expression in set-analysis as variable

Mark_Winter — Wed, 30 Jun 2021 14:05:40 GMT

My pleasure 😁🍻