Missing Criteria in Table (1 Viewer)

[jabaker54]

Hello,

I was wondering if there was a special character you entered into the column area if you have missing data.

For example,

I am trying to run some statistical analyses using a pivot chart. I want to make sure that every box in a specific column is filled. For some of rows I am missing numbers for some of there columns. If there is missing data do I put a wild card?

EXAMPLE:

First Last Middle Average

John Smith Adam 100

Smith John Peter (Blank) <--- no data

(Now if I were to find the average of both it wont run)


Thanks for all the help!

Justin

 

[spikepl]

Really? How do you wish to run average on a set containing one value and no value? The Average function disregards the fields with no value and quite right too, isn't it?

 

[jabaker54]

I was dumb. It works. I just have to make sure the column is labeled "number" for data type.