Newbie Questions

Re: sum of secondary data

erzon — Thu, 13 Feb 2020 00:47:14 GMT

Hilary Stoupa:
Right. This in the XPath: xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW gets replaced by current()/.. which basically means "From this current node, go up the tree to the the repeating my:SharePointListItem_RW group, and find the my:Items node in that same group as I am in".

Thank you so much. This really help you save my day.

Re: sum of secondary data

Hilary Stoupa — Wed, 12 Feb 2020 17:01:14 GMT

Right. This in the XPath: xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW gets replaced by current()/.. which basically means "From this current node, go up the tree to the the repeating my:SharePointListItem_RW group, and find the my:Items node in that same group as I am in".

Re: sum of secondary data

erzon — Wed, 12 Feb 2020 11:41:33 GMT

Hilary Stoupa:
The reason you are getting only the first one is because the XPath is using absolute paths instead of relative paths. If the field is in the my:SharePointListItem_RW group, I'd try something like this: sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity2[current()/../my:Items = ../d:Item2]) + sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity1[current()/../my:Items = ../d:Item1]) + sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity3[current()/../my:Items = ../d:Items3]) + sum(../my:Quantity)

oh my god this works perfectly. So i just need to add the current() code?

Re: sum of secondary data

Hilary Stoupa — Tue, 11 Feb 2020 15:39:18 GMT

The reason you are getting only the first one is because the XPath is using absolute paths instead of relative paths. If the field is in the my:SharePointListItem_RW group, I'd try something like this: sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity2[current()/../my:Items = ../d:Item2]) + sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity1[current()/../my:Items = ../d:Item1]) + sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity3[current()/../my:Items = ../d:Items3]) + sum(../my:Quantity)

Re: sum of secondary data

erzon — Tue, 11 Feb 2020 15:08:17 GMT

Hilary Stoupa:
Could I see a copy of your form? You can attach it under the Options tab in a reply.

Sorry we are not allowed to upload anything but this is the default value of the field sum(Quantity2[Items = Item2]) + sum(Quantity1[Items = Item1]) + sum(Quantity3[Items = Items3]) + sum(Quantity) or

sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity2[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Items = ../d:Item2]) + sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity1[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Items = ../d:Item1]) + sum(xdXDocument:GetDOM("COO Store")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Quantity3[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Items = ../d:Items3]) + sum(../my:Quantity)

The problem the only first field with sum is the one showing as a result

Re: sum of secondary data

Hilary Stoupa — Mon, 10 Feb 2020 21:59:24 GMT

Could I see a copy of your form? You can attach it under the Options tab in a reply.

Re: sum of secondary data

erzon — Mon, 10 Feb 2020 21:02:02 GMT

Hilary Stoupa:
I need more info. I don't know what "not working" means here - the number isn't what you expect? The formula returns an error? You can't get the formula editor to accept the formula? etc....

the correct total is not showing and it only compute the first field but the other field it seems ignored

Re: sum of secondary data

Hilary Stoupa — Mon, 10 Feb 2020 19:09:47 GMT

I need more info. I don't know what "not working" means here - the number isn't what you expect? The formula returns an error? You can't get the formula editor to accept the formula? etc....

sum of secondary data

erzon — Mon, 10 Feb 2020 17:27:36 GMT

I have 5 fields that are coming from secondary data. They are all in numeric format. What I need to do is once the user select the items in the list it will check how many quantity of that items from field1 to field5 and add them together.

I tried 1 field and it's working fine but when I sum all 5 fields like sum(field1) +sum(field2) it's not working. all of files include filter already if the items = items in other list.

Is the anyway to fix this?