2 variables in set analysis

jheasley — Wed, 25 Sep 2019 19:34:35 GMT

Hello All - i have bumped into a weird problem. I need to to an Aggr(only(_LANE_ID_WF),_LANE_ID_WF), but my set analysis has 2 variables:

1: $(wf_ADD) - contains an expression with set analysis
2: $(t_toplanes) - contains a number between 5 and 25
need: only show values where the rank of wf_add is less than t_toplanes

the following is NOT working:
aggr(Only({<
_LANE_ID_WF = {"=Rank($(wf_ADD)) <='$(t_toplanes)'"}
>}
_LANE_ID_WF), _LANE_ID_WF)

help!

Re: 2 variables in set analysis

treysmithdev — Wed, 02 Oct 2019 19:36:10 GMT

Usually with AGGR you need to add set analysis to both the inside and outside expressions.

See if this works:

Only({<_LANE_ID_WF = {"=Rank($(wf_ADD)) <='$(t_toplanes)'"}>} aggr(Only({<_LANE_ID_WF = {"=Rank($(wf_ADD)) <='$(t_toplanes)'"}>}_LANE_ID_WF), _LANE_ID_WF))

topic 2 variables in set analysis in App Development

2 variables in set analysis

Re: 2 variables in set analysis