Search results

Thanks CJ London - I have been able to work things out. Regarding the suggestion to use NULL - at least with Power Pivot Tables you can not calculate average when a "NULL" cell comes into play. Blank cells are not counted in the computtion of average. Thanks for the input - Workhorse

Looking at your response are you suggesting that within the query I include the criteria <>0 for the calculated field which I called "Outcome" in my example? If so, would that not eliminated a great deal of records in which I need data from other fields? I thank you for taking the time to...

Currently using a lot of Power Pivot Tables which in part calculate "averages" - but when the data comes form a Query that contains a calculated field using the iff() funtion such as: Outcome: iff(Status = "P", 1,0) we end up with a lot of zeros that create a problem in calcuating a true...