Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago

Count all cells, including the blank fields

Hello,   I want to create a table visual with values from two different tables. One is the Shelftable on the one side and the n-table with all orders. My problem lies in the count of blank fields: ...
Need Help
Show and Tell
Tutorial Requests
Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago

thank you for the quick response amitchandak , but both don't work:

isn't "+0" only for displaying values as 0 instead of leaving it empty?  But my problem that it should count that cell as well. I think the problem is in fact due to the field is empty and from another table, where it has no value instead of a simple empty field in the same table. 

Hope there is a solution to that. 

Best. 

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Applicable88 , Total 11 is already the correct sum.  Do want add 1 for each blank. Then what is causing a blank should be know

Sum(Table,coalesce([value],1))

 

But the help when value is blank