topic Re: Set Analysis: Cant get condition working in App Development

Set Analysis: Cant get condition working

eikenberg — Thu, 29 Feb 2024 09:37:33 GMT

Hello,

i cant get this set analysis working. The commented out one is working, but i want sums for max available year, max available year -1, etc

JAHR = year column
NETTOTOTAL = total column

/*
Sum(
{$<
JAHR={2024}
>}
NETTOTOTAL
)
*/

Sum(
{$<
JAHR={"=$(=(Max(JAHR)))"}
>}
NETTOTOTAL
)

The data is fetched from oracle

SELECT to_char(belegdatum, 'yyyy') AS Jahr,
...

Any hint how to slove this?

Thanks

Re: Set Analysis: Cant get condition working

Or — Thu, 29 Feb 2024 09:41:58 GMT

Try changing Jahr to a numeric value as Max() works with numeric values. Alternatively, try using MaxString().

Re: Set Analysis: Cant get condition working

Clement15 — Thu, 29 Feb 2024 10:12:37 GMT

Hello,
I think the = is too much.
Try this:
Sum(
{$<
JAHR={"$(=(Max(JAHR))"}
>}
NETTOTOTAL
)

Re: Set Analysis: Cant get condition working

mohamedafzal — Thu, 29 Feb 2024 09:56:27 GMT

Can you try the below:
Sum({$<JAHR={$(=Max(JAHR))}>}NETTOTOTAL)

Re: Set Analysis: Cant get condition working

ali_hijazi — Thu, 29 Feb 2024 09:59:26 GMT

if you put the max(JAHR) in a text object what does it return?

Re: Set Analysis: Cant get condition working

eikenberg — Thu, 29 Feb 2024 10:11:07 GMT

This is working. Thanks.

But the syntax is hard to read and confusing. While in the commented out version i get the correct results for 2024 as number and string, the dynamic only works with MaxString.

Also a this is working

Sum({$<JAHR={"$(=MaxString(JAHR))"}>}NETTOTOTAL)

while an pair of extra brackets will not

Sum({$<JAHR={"$((=MaxString(JAHR)))"}>}NETTOTOTAL)

Re: Set Analysis: Cant get condition working

henrikalmen — Thu, 29 Feb 2024 10:11:10 GMT

You haven't said what the problem is/what unexpected result you are getting, but perhaps try this:

Sum({$<JAHR={$(=(Max({1}JAHR)))}>}NETTOTOTAL)

Re: Set Analysis: Cant get condition working

eikenberg — Thu, 29 Feb 2024 11:23:26 GMT

I had gotten a total of 0 or a sum of all records.

Your solution works too and reacts independent to already filtered data. Thanks.