My report isn't displaying correct data
This report has two cells that are blank when the underlying cells say "/". I have shared the report and underlying sheets. Can anyone please help me figure out why this is occurring? The formulas are the same on all 3 sheets.
=IF(COMP36 = "Y", " ", COMP36)
In all 3 sheets, "/" is in the COMP36 field and the "/" shows up in the sheet fine, just not on the report for two out of three of these.