embedded expressions

[Anonymous]

Hi,

My task is to select all existing values of the field Media regardless of a user's selection and then inside this set of values I should select only those media whose Budget >0 and count them those media.

The first step is to get all media regardless of a user's choice:

Expression1: {Media=}

The second step to get the media whose Budget >0:

Expression2: {<Media = {"=aggr(sum([Budget]), Media)>0"}>}

Now I need to calculate expression 2 inside expression 1.

Intersection '*' doesn't work.

Could you please advise something?

Thank you in advacne,

Larisa

[MK_QSL]

SUM({<Media ={"=SUM({1}Budget)>0"}>}Budget)

[MayilVahanan]

Hi

Try like this

{<Media = {"=aggr(sum( {<Media=>}[Budget]), Media)>0"}>}

[lironbaram · Accepted solution]

you can try this one

=count({<Media=>}aggr(if(sum({<Media=>}Budget)>0,only({<Media=>}Media)),Media))