Forum Discussion
Solved
Incorrect Average Result
Hi I have a table that consists of 2 columns (Type,Value) there are some values that are blank means they are Zeros I want to calculate the average of values including the blanks (ex Average...
values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks
values ignores blanks, it would be best to set those blank values to 0 or use distinctcount which counts blanks