Set anslisys: inner functions

[aisolomatin]

Hi! Need your help!

I got issue with including additional condition in set analysis.

I got 2expressions:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"}>} uk_bex.Stat)

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat)

I need to combine both expressions in one and get in result someting like this:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"},

sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat)

But it doesn't work.

[Anonymous]

Try:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"} , uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat>} uk_bex.Stat)

OR adding the two

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"}>} uk_bex.Stat)

+

sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>} uk_bex.Stat)

[rubenmarin · Accepted solution]

Hi, when you say 'combine' is sum both expressions or apply both set analysis in one expression?, in case it's the second one, you can try with:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min) and sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>}uk_bex.Stat)

or:

=sum({<uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Stat)>=$(v_stat_min)"}>

* <uk_bex.urf_code={"=sum({<uk_bex.urf_code-={''}>} uk_bex.Vacan)>=$(v_vac_min)"}>}uk_bex.Stat)

[aisolomatin]

Thank you, Ruben!

First expression works great!