Is there a way to prevent the display of "?" in a calculation dependent upon one or more fields that contain no data?
My formula calculates a percentage based on sales in a data range for a specific product. If there are no sales for that product in the date range, FileMaker returns a "?". It's distracting from the layout and I would like to show nothing if the result is "?".