Expression help

[#1]

Hi,

I got this expression which return the right figures to me (so far so good)

sum(aggr(sum({<Crop={'*'}>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

I have a field/filter called 'CPM'

How do I implement that the figues returned from the expressions will be the same no matter what I select in 'CPM' ?

In other words: No mater what I select using CPM filter the figures calculated in my expression wont change.

Thanks in advance,

Kenneth

[maximiliano_vel]

Try

=sum(aggr(sum({<Crop={'*'}, CPM>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

[sunny_talwar · Accepted solution]

Try this:

=Sum({<CPM = >}Aggr(Sum({<Crop={'*'}, CPM =>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

[maxgro]

try to disregard the filter on CPM

sum(aggr(sum({<Crop={'*'},CPM=>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

[awhitfield]

HI Kenneth,

try this:

sum(aggr(sum({<Crop={'*'},CPM=>} distinct AREAL),UNIQ_NO,KorrAfgrødeUK))

Andy

[awhitfield]

That looks pretty conclusive! Ha ha!

Andy