Level 1

0% to

Level 2

Tip /

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

View all

lisab73316618
Offline

6

Accepted Solutions

Accepted Solutions
0

Likes

Likes
1

Posts

Posts
6

Discussions

Discussions
0

Questions

Questions
6

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Re: Need to count cells >0 from multiple tables and display Total Count - Adobe LiveCycle 28-11-2017
That worked! I have been struggling with this form for days... Thank you so much!

Views

922

Likes

0

Replies

0
Re: Need to count cells >0 from multiple tables and display Total Count - Adobe LiveCycle 28-11-2017
I tried the following but maybe I'm missing something. (both fields could be blank at some point until the user starts filling in the blanks.I googled this to get rid of my zero division and I do get the calculation but I want to get rid of the error message.Do I need another if statement? and how would I do that? if(HasValue(Row2.RawCount&Row2.RawCount>0)) then (Row2.RawCount/Row3.Avail) else null endif

Views

757

Likes

0

Replies

0
Re: Need to count cells >0 from multiple tables and display Total Count - Adobe LiveCycle 27-11-2017
I forgot to add that the Raw and Avail cells are calculated if that makes a difference. Thanks.

Views

754

Likes

0

Replies

0
Re: Need to count cells >0 from multiple tables and display Total Count - Adobe LiveCycle 27-11-2017
Bruce,I'm sure that would work but I couldn't get it to with my limited knowledge. However after poking around, I did get an if statement to calculate each table for me and then I used sum to add each to get to my total count. Probably the long way around but it works. Here's my next question if you can help. I want to take the sum (Raw) and divide by the Count (Avail) to get a Score. I thought that was pretty simple but I get the following error using this. - but it still gives me the correct a...

Views

745

Likes

0

Replies

0
Re: Need to count cells >0 from multiple tables and display Total Count - Adobe LiveCycle 23-11-2017
I'm sorry. I am quite the novice with LC. Can you give me more info or an example of an if statement that counts?

Views

758

Likes

0

Replies

0
Need to count cells >0 from multiple tables and display Total Count - Adobe LiveCycle 22-11-2017
I created a performance evaluation form that has multiple tables (6) (all have two columns with the last row/column of each table a total of possible points for that section).At the end of the form I want to be able to count all the 2nd columns (not the totals) that are >0 and display that number.Any help would be greatly appreciated.

Views

2.4K

Like

1

Replies

9
Likes from