Adding up null/blank value from a Pivot Table in a KPI

Bradlabs12 — Sat, 16 Nov 2024 03:34:27 GMT

I am little new to this product , so hopefully I describe my problem clearly.

I am trying to create a KPI that looks at a pivot table for any time a columns has a blank/null value.

If there is a blank/null value anywhere within the column then that column should be counted in the KPI

I have attached a copy of the pivot table

Thanks for any help

Re: Adding up null/blank value from a Pivot Table in a KPI

Arthur_Fong — Thu, 16 Jan 2020 05:18:28 GMT

Try this:

=count(if(len(<Dim>)=0,1,null()))