Search results for 'preceding-sibling'

Re: sum preceding nodes in repeating sections

Hilary Stoupa — Tue, 30 Jan 2024 15:15:26 GMT

I've attached a sample form. Right click the linked form, select save as to save locally. Right click the saved form, select Design to open in design mode, then preview. I used your XML as a secondary data source. I think there may be two issues with your formula - but I don't know how your form is set up. That is, I don't know where the control using your formula is located. You'll see in my form, the balance column is inside the repeating table - so the context is the repeating "StatementLine" node. Yours, since I see "../../../" in it, I'm assuming it is somehow not in the repeating table. I would think for a running table, you need the sum of the preceding rows along with the current row values, like: sum(preceding-sibling::dsStatement:StatementLine/dsStatement:InvoiceCharge) + sum(preceding-sibling::dsStatement:StatementLine/dsStatement:InvoiceCredit + dsStatement:StatementLine/dsStatement:InvoiceCharge + dsStatement:StatementLine/dsStatement:InvoiceCredit

Re: sum preceding nodes in repeating sections

stevec — Tue, 30 Jan 2024 14:31:41 GMT

I know this is an older thread but hoping for some assistance. My XML (nodes) look like this - replacing the arrow brackets with round for formatting

(dsStatement)

(tt-printdata)

(EmailSubject)Statement(/EmailSubject)

(/tt-printdata)

(StatementHeader)

(CompanyNo)5000(/CompanyNo)

(StatementLine)

(InvoiceCharge)689.0(/InvoiceCharge)

(InvoiceCredit)0(/InvoiceCredit)

(/StatementLine)

(StatementLine)

(InvoiceCharge)0(/InvoiceCharge)

(InvoiceCredit)-89.0(/InvoiceCredit)

(/StatementLine)

(StatementLine)

(InvoiceCharge)129.0(/InvoiceCharge)

(InvoiceCredit)0(/InvoiceCredit)

(/StatementLine)

(/StatementHeader)

(/dsStatement)
My desired output would be an extra column that gives me the running total of the statement.

Charge Credit Balance

689.00 0 689.00

0 -89.00 600.00

129.00 0 729.00

I tried the following (don't get any errors) but just calculates as 0.00

sum(../../../preceding-sibling::dsStatement:StatementLine/dsStatement:InvoiceCharge) + sum(../../../preceding-sibling::dsStatement:StatementLine/dsStatement:InvoiceCredit) I've tried re-creating this with no luck so any help / assistance would be greatly appeciated.

Re: Repeating Table Issues

Hilary Stoupa — Thu, 20 Jan 2022 23:53:53 GMT

I'll try to upload a copy w/ changes tomorrow. I do see on the repeating table formatting you are comparing title to category in the preceding-sibling condition - that would be why they are all hiding.

Re: Repeating Table Issues

Froman — Thu, 20 Jan 2022 17:26:06 GMT

That's what I thought, but it hides everything. which in turn causes the sum to not work properly (i think?). just to confirm, the preceding-sibling rule goes on the repeating table and the sum formula would be used 4 times, one for each quarter? what about category in the repeating table? I was just using d:category, but does that need a formula as well (current() perhaps?) I changed the DC for IBP to save the data (junk) into the form and reattached

Re: Repeating Table Issues

Hilary Stoupa — Thu, 20 Jan 2022 00:10:33 GMT

So - this is on the Totals view? You want each category to display only one time? That would be a preceding-sibling condition - hide if category = preceding-sibling category. d:Category = preceding-sibling::d:SharePointListItem_RW/d:Category is the expression I'd try. Then for your sum formula - probably something like this (for each of your quarters that you are adding together): sum(xdXDocument:GetDOM("IBP")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Category = current()/d:Category]/d:_x0051_1)

Re: Repeating Table Issues

Froman — Wed, 19 Jan 2022 20:29:22 GMT

I can't seem to get something else to work, I've got a new page with a similar repeating table on it, but am having issues getting it to display the way I want it. This table needs to be a sum of years per category. I am fairly certain I need to use preceding:sibling and/or the current() function to get it to hide unwanted rows. right now it will show the category for each year, I would like it to only show the categories once (rule preceding sibling on repeating table?) and then sum the YTD of all years per category. I feel like the category in the repeating table should be using current() and the repeating talbe should hide preceding sibling, but I can't seem to make it come together. am I way off base in the rules/formulas I need. or can this not even be done? Thanks

Re: How to manage Progress Status movements in a form

markikav — Thu, 09 Sep 2021 17:39:58 GMT

Awesome Hilary this helps alright, thanks!

So it's a one column SharePoint list to hold the stages 1-> 12 for example.
Then in the form Stages field entries set the filter exactly as you have, selecting the correct field that holds the values form the external list,

preceding-sibling::Status[1] = xdXDocument:get-DOM()/my:myFields/my:field1
following-sibling::Status[1] = xdXDocument:get-DOM()/my:myFields/my:field1

And this allows you to go to the next stage or back to the previous stage.

I know they have multiple jump off points at some stages i.e. it could possibly go down a happy path or an alternative path, is this possible too or are we limited to one stage movements?

This is great though thanks!

Repeating Table

Froman — Fri, 23 Jul 2021 20:00:04 GMT

Hi, I'm having an issue getting a repeating table to show only what I want it to, and I'm not sure if want I want is even possible. The repeating table is supposed to only show vendors when the work category matches their "profile" which is currently does, but it leave blanks when you change the work category, I cannot seem to make the table arrange itself when the amount of vendors changes. I tried to use preceding sibling, but for whatever reason its not working. I've attached my form if anyone can take a quick look. Thanks

Re: Unique values from repeating table

ncodename.sabir — Thu, 10 Jun 2021 04:51:36 GMT

Thank you very much Hilary! One more little problem is all values from table is setting to field. I need only Drawing_no field to be there (marked with yellow). I don't need a cable tag to be there. xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Electrical_requisiton_Drawings")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[not(d:Drawing_No = preceding-sibling::d:SharePointListItem_RW/d:Drawing_No)], 'concat(., ";")'), "..")

Re: Unique values from repeating table

Hilary Stoupa — Wed, 09 Jun 2021 16:16:01 GMT

I've attached a sample - right click and save locally, right click, select design and preview. Add some rows to the repeating table, and set some of the fields to the same value. For your formula, I'd try: xdMath:Eval(xdMath:Eval(xdXDocument:GetDOM("Electrical_requisiton_Drawings")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[not(d:Drawing_No = preceding-sibling::d:SharePointListItem_RW/d:Drawing_No], 'concat(d:Drawing_No, ";")'), "..")