InfoPath 2010

Re: Help for Xpath Formulas

Patrick Halstead — Sun, 01 Sep 2013 23:00:15 GMT

Just add a filter. count(agent[loc='location1']) will give you the count of all agent fields where loc is equal to location1. Substitute your own fields and give it a try or use InfoPath filter dialog to have it create the xpath for you.

Re: Help for Xpath Formulas

Ghaith — Mon, 26 Aug 2013 05:01:05 GMT

Thank You very Much for your Help , I did it and it working fin but what about counting for Number of Agent in each location" First Culomn in above table "

Thanks Again

Re: Help for Xpath Formulas

Patrick Halstead — Sun, 25 Aug 2013 01:38:17 GMT

Hi Ghaith and welcome,

You seem very close to a solution. Assuming you have a query that loads all of the data from this list (when the form opens or on some buttom click), you'll want to have two rules - one for supervisor and another for agent. If the supervisor opens the form (use a field with a condition) then your supervisor rule will set a value equal to the sum with a filter where "Target for equals 'supervisore'". For agents, if you need to divide by the number of rows for that agent, you can use the count() xpath function with a filter for the rows equal to that agents Name in English, or just "Target for equals 'Agent'" if it's for all agents.

Good luck!

Help for Xpath Formulas

Ghaith — Thu, 22 Aug 2013 09:41:26 GMT

Hi All ,

I need your help please as I want to Set Target Formulas for Conflicted sheet

I made list in Share point included the main target for each location then i connected with Staff target as each employee has individual target

then i tried to make the Formulas for staff target as below

if the Target for Column = Supervisor then get IPhone

if the Target for Column = Agent then count Agent in Location and div. the I phon

the Formulas i has made it as below but it is need to correct

Iphon / sum((Target for=Agent)) or sum((Target for=Supervisore)

Location	Name in English	Target for	I Phoen	Blackberry	Nokia
FOD-1	Different Name	Supervisore
FOD-1	Different Name	Agent
FOD-1	Different Name	Agent
FOD-1	Different Name	Agent
FOD-1	Different Name	Agent
FOD-1	Different Name	Agent
FOD-1	Different Name	Agent
FOD-1	Different Name	Agent
FOD-2	Different Name	Supervisore
FOD-2	Different Name	Agent
FOD-2	Different Name	Agent
FOD-2	Different Name	Agent
FOD-2	Different Name	Agent
FOD-2	Different Name	Agent