'Pass variable value too measure expression

I set a function and a variable containing values as such:

SET vFracAggrAvg = fractile(aggr((avg({$<$3={$4}>}$1)),$2),$5);

SET vPercentiles = 0.05,0.10,0.15,0.20,0.25,0.30,0.35,0.40,0.45,0.50,0.55,0.60,0.65,0.70,0.75,0.80,0.85,0.90,0.95;

Now I created a table with

=Valuelist($(vPercentiles))

as dimension column to get one of the variable values per row.

In a second column I set

=$(vFracAggrAvg(BD100,Beslag,[Reg Maand.autoCalendar.YearsAgo],3,Valuelist($(vPercentiles))))

as measure, hoping to get in each row the calculated value for the corresponding variable value as $5 parameter.

This doesn't work as expected however and I just get gray cells with a '-': enter image description here

Anyone know how I could get the desired result?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source