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

live cycle calculations

Avatar

Avatar
Level 1
mohama32406181
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
mohama32406181
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
View profile
mohama32406181
Level 1

08-09-2016

Hello,

I have made form using adobe live cycle es2 : I have numeric fields that I want to get their median ... I know that there is average in formcalc but for example:

Cell 1=  5

Cell 2=  3

Cell 3=  6

Cell 4=  2

median is = (5+3+6+2)/4    the 4 is the number of cells.... this is easy to obtain

my problem is that if one cell is empty or = 0    so I need to exclude this cell from the equation for example:

Cell 1=  5

Cell 2=  3

Cell 3=  0

Cell 4=  2

here I don't want to include cell 3 because it is = 0 only I want (5+3+2)/3

please can any one help me....

thanks

Accepted Solutions (0)

Answers (0)