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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Elgen55
Elgen55
Offline

Badges

Badges
5

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
12

Discussions

Discussions
0

Questions

Questions
3

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Elgen55
Customize the badges you want to showcase on your profile
Re: Trouble with the average function. - Adobe LiveCycle 21-02-2014
Thank you I will give that a try. I will try to make it a dynamic table and go from there.

Views

289

Likes

0

Replies

0
Re: Trouble with the average function. - Adobe LiveCycle 21-02-2014
I hope I am getting this right. The line is Avg(Row3.PSI,Row4.PSI,Row5.PSI[*])

Views

286

Likes

0

Replies

0
Re: Trouble with the average function. - Adobe LiveCycle 21-02-2014
I guess I don't understand what you mean by validating the field, I thought that is what the [*] was supposed to do by not using the null cells.

Views

286

Likes

0

Replies

0
Trouble with the average function. - Adobe LiveCycle 21-02-2014
I am still having a problem getting my form to calculate an average the way it should. On one form I did when I set up an formcalc to average ten places and not average any cell that is blank or null I used the [*] and works just fine, but on the next form that I did that only has three rows it includes the null cells even through I used the [*] function. What am I doing wrong?

Views

1.4K

Likes

0

Replies

7
Re: Why can't I get the average function work with empty cells? - Adobe LiveCycle 19-02-2014
The thing that I am having a problem with is that I made a different form that calculates the average no matter how may of the cells have numbers or not and I didn't use an if function. I have tried with this other form and and it calulates as if all the cells where being used. I am using the [*] in both instances but it only works in the one I did earlier.

Views

104

Likes

0

Replies

0
Why can't I get the average function work with empty cells? - Adobe LiveCycle 18-02-2014
Why can't I get the average function work with empty cells?

Views

430

Likes

0

Replies

2
Re: Adding a day to a date? - Adobe LiveCycle 26-11-2013
Thanks for the suggestion, I really appreciate it.

Views

156

Likes

0

Replies

0
Re: Adding a day to a date? - Adobe LiveCycle 26-11-2013
It is a dropdown field but the user can change if needed.

Views

154

Likes

0

Replies

0
Re: Adding a day to a date? - Adobe LiveCycle 26-11-2013
Thanks for the suggestion.Ken Elgen

Views

155

Likes

0

Replies

0
Re: Adding a day to a date? - Adobe LiveCycle 26-11-2013
I tried that formula and now it is going back to 1/1/1900 + number. Should I make some kind of var to make it this year?

Views

157

Likes

0

Replies

0