Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))