I'm trying to calculate an Average in a PowerPivot table on a column that contains numbers and blanks - but the blanks are not true blanks, but rather "" values. I need to Average where there is not a "". For instance,
Values:
1
2
3
""
4
Should calculate as (1 + 2 + 3 + 4) / 4 values that are not "".
This is the default behavior of the standard AVERAGE or use in Pivot Tables, but not so in Power Pivot. How can I write a formula that will ignore those blanks?
Values:
1
2
3
""
4
Should calculate as (1 + 2 + 3 + 4) / 4 values that are not "".
This is the default behavior of the standard AVERAGE or use in Pivot Tables, but not so in Power Pivot. How can I write a formula that will ignore those blanks?