AnsweredAssumed Answered

prevent display of ?

Question asked by sccardais on Apr 1, 2018
Latest reply on Apr 2, 2018 by steve.thoms

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 "?".

Outcomes