xyzcoucou
Community profile xyzcoucou Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 19-12-2014 9:04:31 AM
Offline
Top badges earned by xyzcoucou
Customize the badges you want to showcase on your profile
Re: FormCalc error using count in a dynamic form with repeat row min set to 0
Avatar
Give Back
Level 1
xyzcoucou
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
xyzcoucou
- Adobe LiveCycle
I solved the problem using resolveNodesvar I=form1.INCOMES_TAXED.DATA.resolveNodes("Row1[*].DATA.RowDetail[*].AMT_CHF").lengthif (I > 0) then $=sum(DATA.Row1[*].DATA.RowDetail[*].AMT_CHF) else $=0 endif

Views

491

Likes

0

Replies

0
Re: FormCalc error using count in a dynamic form with repeat row min set to 0
Avatar
Give Back
Level 1
xyzcoucou
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
xyzcoucou
- Adobe LiveCycle
I made some tests using "_RowDetail" (as I am interested in testing the second level) but I didn't succeed with a 2 level Table as:It is why I tried to use the count on the XML structure that is bind on it, hoping to be able to check if there is a TAX_CHF element in: "$record.INCOMES_TAXED.INCOME_TAXED[*].DETAILS.DETAIL[*].TAX_CHF. But this is when I get the error accessor $record.INCOMES_TAXED.INCOME_TAXED[*].DETAILS.DETAIL[*].TAX_CHF is unknown".

Views

491

Likes

0

Replies

1
FormCalc error using count in a dynamic form with repeat row min set to 0
Avatar
Give Back
Level 1
xyzcoucou
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
xyzcoucou
- Adobe LiveCycle
Hi,I am generating a flowed table with 2 aggregation levels using a XML data binding. 1st level INCOMES_TAXED, 2nd level DETAILSThe following formula works nicely as long as there is a minimum of 1 RowDetail displayed.if (count($record.INCOMES_TAXED.INCOME_TAXED[*].DETAILS.DETAIL[*].TAX_CHF)>0) then$=sum(DATA.Row1[*].DATA.RowDetail[*].TAX_CHF)+0endifWhen the XML data file has no DETAILS for IMCOMES_TAXED, no RowDetail are displayed in the table and then I get the following error:accessor $record...

Views

776

Likes

0

Replies

3