I have built a FOCUS temporary table by appending multiple reports using App Studio 8.2.01M. When I create a final report from this temporary table, I need to suppress zero values in aggregated columns. I'm trying to both suppress and include commas in my total values. This works until I attempt to open my procedure after saving. This generates an Error parsing report req... window with >/< TOTAL/I7CS displayed. I've tried to find my answer in FPF, but unable to do so. Can a number be formatted with both commas and zero suppression?This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 7.6 Windows, All Outputs
May 18, 2018, 04:44 PM
BabakNYC
Can you share a simplified example? I7CS shouldn't be a problem.
WebFOCUS 8206, Unix, Windows
May 18, 2018, 06:16 PM
Doug
By ""suppress" do you mean "eliminate" or don't show/use those values in your display or in your calculations? the "I7CS" is only for formatting the result.
May 21, 2018, 08:50 AM
Tom Flynn
At top of fex: SET NODATA = '' then redefine the column. Example: D_YOUR_COLUMN_NAME/I7C MISSING ON = IF YOUR_COLUMN_TEST IS MISSING THEN MISSING ELSE YOUR_COLUMN_TEST; OR D_YOUR_COLUMN_NAME/I7C MISSING ON = IF YOUR_COLUMN_TEST EQ 0 THEN MISSING ELSE YOUR_COLUMN_TEST;
Sorry to just get back with this. Thank you all for your advice given. Before sending code to you, I decided to follow Mr. Flynn's example. Worked great! Thank you everyone!!!