Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

xyzcoucou
Community profile xyzcoucou Level 1
Job title here
Location here
0 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
Level 1
xyzcoucou
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
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

475

Likes

0

Replies

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

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
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

475

Likes

0

Replies

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

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
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

760

Likes

0

Replies

3