topic Re: Set Expressions >*< vs , separation in App Development

Set Expressions >*< vs , separation

LReeve — Sat, 16 Nov 2024 07:49:02 GMT

Hi Guys,

Had a search but can't seem to find a definitive answer. I have a simple Set Expression where I am trying to get:

Sum of Sales
Greater than my variable
Of Type 1

Can anyone confirm why the below set expressions gives different results so I can ensure I always use the correct format going forwards.

Sum({<Field1 = {">$(vMyVariable)"}>*<Field2 = {"2"}>} Sales)

and

Sum({<Field1 = {">$(vMyVariable)"}, Field2 = {"2"}>} Sales)

I've always been lead to believe they are the same?

Thanks in Advance!

Re: Set Expressions >*< vs , separation

petter — Mon, 13 Aug 2018 19:03:45 GMT

Well if you have user-selections on either of the two fields the expressions will not necessarily give the same results. If you don't have any selections on the fields then they will give the same. Think about it...

Re: Set Expressions >*< vs , separation

petter — Mon, 13 Aug 2018 19:09:38 GMT

However if you change the first expression into this:

Sum({<Field1={">$(vMyVariable)"},Field2=>*<Field1=,Field2 = {"2"}>} Sales)

It should be equivalent to:

Sum({<Field1 = {">$(vMyVariable)"}, Field2 = {"2"}>} Sales)

The second expression should be quite a bit more performant I would believe...

Re: Set Expressions >*< vs , separation

LReeve — Tue, 14 Aug 2018 08:45:37 GMT

Thanks Peter!

Very useful and logical explanation.

Re: Set Expressions >*< vs , separation

petter — Tue, 14 Aug 2018 10:36:41 GMT

You're welcome