Based on your description, it sounds like it might be best to filter out records where the Number = 0. Would that work? Feel free to post a packaged workbook if needed so we can take a look and see what might be best. Thanks!
I tried it before posting my question and the result wasn't what I expected (it worked for some values but not all of them).
Now that I've reopened the file, everything seems to work perfectly.
FYI, I'll attach the resulting file.
PData - Home - Work.twbx.zip 159.1 KB