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

[LucasS]

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).

1.

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

2.

vAppCalculate: =Expression

3.

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

[vinieme12]

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

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

[anat]

same logic can u define in front end object.

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

[LucasS]

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

[LucasS]

Okay, in that case it seems impossible to achieve.