How do I suppress a NULL or zero value in fields from a query used to create a PivotChart? The expression that I'm using is, TestField_Result: Sum(iif([Test])= -1,1,0)).
As that expression stands now, it'll give me the value of that field (>0 or =0) BUT I'm looking to suppress that value to appear in my PivotChart if the result IS zero.
As that expression stands now, it'll give me the value of that field (>0 or =0) BUT I'm looking to suppress that value to appear in my PivotChart if the result IS zero.
Last edited:
