Using a Filter to select values to recalculate expressions

[jrr9763]

Hello,

I need to be able to allow users to select a value from a filter like the one I'm creating below.  So if the user selects any of these percentages that percentage will apply to an expression in a chart.  For example if they select 10% and the expression is Call Off * Sum(FTE) if the FTE sum is 100 the result will be 10 (10%*100), if they select 20% it would be 20 (20%*100).

SelectorMeasuresCallOff:
LOAD * INLINE [
10%
11%
12%
13%
14%
15%
16%
17%
18%
19%
20%
21%
22%
23%
24%
25%
];

[Kushal_Chawda · Accepted solution]

@jrr9763  try below expression

Sum(FTE) * alt(Percent ,1)

where Percent is the field name which contains Percentage values