Using a Filter to select values to recalculate expressions

jrr9763 — Thu, 16 Sep 2021 20:40:22 GMT

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%
];

Re: Using a Filter to select values to recalculate expressions

Kushal_Chawda — Thu, 16 Sep 2021 22:04:00 GMT

@jrr9763 try below expression

Sum(FTE) * alt(Percent ,1)

where Percent is the field name which contains Percentage values

topic Re: Using a Filter to select values to recalculate expressions in App Development

Using a Filter to select values to recalculate expressions

Re: Using a Filter to select values to recalculate expressions