InfoPath Dev

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) 

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!

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

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.