This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
You can solution this by rolling the field up, showing NaN, then creating a second field that is a IF formula, removing any items that are NaN. IF({Rollup-Field}="NaN", BLANK(), {Rollup-Field})