rows not suppressing in Reports when column formulas are present
Summary:
I have a simple example where I have formula column in a report (Column D) with a simple formula [B]-[C] to calculate a variance. I have row suppression = True for all options (No Data, Zero, etc.), but the rows are not suppressing even though the value in both Column B and C are #missing. The formula seems to be returning a value that is not allowing the suppression
Content (please ensure you mask any confidential information):
here is a mockup of what is in the report… when i export the report to excel the rows do suppress b/c the formula column is dropped when exporting to excel so I know the row is #missing values