5 of 5 people found this helpful
As there is no weight for Paris, you can replace it with 0 by creating a new weight like this:
Then you can use this weight for the CORR calculation and in that as well replace the null with 0s like this;
or you can club both these calculations in one: zn(LOOKUP(CORR([Height], IFNULL([Weight],0)),0))
And if you use this you will get all the values in the window:
I guess this is the output you are looking for.
Hope this help!
Thank you so much Jayshree!
1 of 1 people found this helpful