I do the same as Brandon, but just set the value to “YB” or “NB”
Usually just make the Calculated field name the original, with _YNB on the end.
To allow filtering parts by active, or Inactive or either, the Calc filed is named Inactive_YNB
The formula is if(Part.Inactive = 1) then 'YB' else 'NB'
Then on the dashboard I hide the Inactive_YNB column on the grid, but have it as a prompt input. I use the “MATCHES” instead of “starts with”. Then the user can enter a Y, N, or B.
And they user doesn’t even need to really enter the ‘B’ for both, as a blank input is ignored.