If Column is Empty

[Front]

I cannot believe I cannot figure this out. I have tried about 20 things and nothing seems to work. They all work with a cell but not table column. I am trying to say if a column in the table is empty then return "NA", otherwise perform the function.

This is what I started to go with.

=IF(ISBLANK(Table134[Close Price Per Contract / Share]),"NA",COUNTIF(Table134[Profit / Loss],">0")/COUNT(Table134[Profit / Loss]))

I also tried using ""<> and then I tried some funky things with IF(SUMPRODUCT(ISNUMBER(MATCH...
But nothing seems to work. It seems like one I should be able to get, but having issue. Any help would be appreciated!

 

[JGordon11]

try using COUNTA = 0 (untested)

=IF(COUNTA(Table134[Close Price Per Contract / Share])=0,"NA",COUNTIF(Table134[Profit / Loss],">0")/COUNT(Table134[Profit / Loss]))

 

[Front]

Thank you that worked!