Associated Field Selection

[#1]

Morning.

Need some help please,

I have a listbox, lets call it team leader, there is a feild associated to that team leader, called department, when i select the team Leader, i want a variable to automatically assign the value of the associated department.

I then want to use that variable to show that department statistics using the formulae

(sum({1<Dept='$(vdeptfqc)'>} percentage)/count(distinct {1<Dept='$(vdeptfqc)'>} call_reference_no))/100

Please Assist

[Gysbert_Wassenaar · Accepted solution]

Why do you want to use a variable? 

Does this expression give you the result you need?

(sum({1<Dept=p(Dept)>} percentage)/count(distinct {1<Dept=p(Dept)>} call_reference_no))/100

[#3]

Hi there,

Thats pure awesomeness, now explain to me what its doing please?

[Gysbert_Wassenaar]

{1<Dept=p(Dept)>} means disregard all selections, but filter the Dept field to those Dept values that are possible values given the selections made.