topic Re: Sum with (dynamic) set expression returns "-" when more than one ID is selected in App Development

Sum with (dynamic) set expression returns "-" when more than one ID is selected

LucasS — Tue, 29 Mar 2022 08:19:27 GMT

Hi Community!

I have this unexpected behavior when evaluating a load script expression in table.

I've generated the expression in the load script and then stored it in a variable which I call in the table like so:
(I've done this because the "Set Expression Here" changes for each ID).

Load
sum(aggr(sum({1<"Set Expression Here">}Value),Value)) as Expression,
ID;

vAppCalculate: =Expression

And then in my table I add $(vAppCalculate) as a measure.

This works whenever I select 1 ID. When one ID is selected $(vAppCalculate) returns 0, because the set expression isn't fulfilled. If I fulfill the expression $(vAppCalculate) correctly returns the Value.

However as soon as I enable all ID's then $(vAppCalculate) returns "-" for all ID's instead of the expected 0 even when the set expression is fulfilled.

Thanks in advance!

- Lucas

Re: Sum with (dynamic) set expression returns "-" when more than one ID is selected

vinieme12 — Mon, 18 Apr 2022 08:39:26 GMT

You cannot have a different formula for each row in your table

Expressions are evaluated only once per chart and not once per row,

Re: Sum with (dynamic) set expression returns "-" when more than one ID is selected

anat — Mon, 18 Apr 2022 08:59:04 GMT

same logic can u define in front end object.

sum(aggr(sum({1<"Set Expression Here">}Value),Value))

Re: Sum with (dynamic) set expression returns "-" when more than one ID is selected

LucasS — Tue, 19 Apr 2022 07:14:53 GMT

Yes, but unfortunetly this doesn't work. The expression is not evaluated probably if done like that unfortunately.

Re: Sum with (dynamic) set expression returns "-" when more than one ID is selected

LucasS — Tue, 19 Apr 2022 07:16:23 GMT

Okay, in that case it seems impossible to achieve.