Calculate completion rate

Dear All,

i have a small Alteryx flow which I use everywhere. It gives me the number of Null values, the number of Blanks and the Non-null values, and a small formula calculate the completion rate : (non null values/total nb of rows)*100.

this little flow is really handy and I copy paste it in every new job.

I have tried to do the same with knime but cannot manage. Ideally I’d like to have it as small as the alteryx one and to be able to copy-paste it in every new job.

Here is what I did so far :

I entered a csv file with lots of columns.

I started with a Column filter node to select the columns

then I used a GroupBy to Count the entries and the Missing value count to count the blank and null values.

then I thought I could use a Math formula node to calculate 1) the difference between the total number of entries and the missing ones and 2) the Completion rate (non null values /total nb of values)*100

I do not find the right node to calculate the completion rate

Could you please bring me some help?

many thanks

Esmé