Exclude selection in expression

[francis_gr]

Hi!

In my attached file,  i have a expression (avg sales/pto) where i calculate the average sales for each position.

When i select a name, the value of the sales average for position (pto) is lost and match the person sales. I need that if i select a name, the average sales value for the position don`t change.

Thanks in advance

[aworrall]

Hi. You can use set analysis in a aggregate field and insert your field name and an equals sign to ignore any selection made in that field. Eg Sum({<[person name]=>}[Total Value]}

[sunny_talwar · Accepted solution]

Change your avg sales/pto expression to this

avg(total <pto> {<name>} sales) * avg(1)

[francis_gr]

Hi Sunny, thanks for your fast reply. That´s works fine.

I have one question

What exactly does avg(1)?

thanks for help

regards

[sunny_talwar]

Avg(1) will equal to 1 for selection and will equal to 0 for out of selection. So, when you select a name, Avg(1) = 1 for the specific name and becomes 0 for the others.  This is needed because we are ignoring selection in Name field for the expression so that the avg is calculated regardless of selection in name field. and then multiplying it with Avg(1) forces the expression to just show the name selected.

[francis_gr]

Ok!

Thanks for the explanation.

[francis_gr]

Hi Aworrall!

I really appreciate your interest in help!

Regards