FocalPoint Community:

I have a business challenge to mask certain values based on the value in another column. I have researched it some on the forum and in the documentation, looking at MASK and MISSING. I'm not sure either option provides a good solution.

Here's a sample of what I'm trying to do:

 Average Sales by Dealership and Sales Representative Totals			
			
	Last Quarter v. Current Quarter		
	2018		
Dealership	#	Avg # Sales Per Person	Avg # Sales Per Person
Alan's Auto Shops	3	3.00	3.25
Barbara's Buick Dealerships	31	8.00	9.50
Cal's Chevrolet Dealerships	93	6.00	7.25
Danny's Dealerships	12	6.50	7.00
Frank's Ford Dealerships	4	4.00	10.25
All Dealerships	143	6.36	7.72
 			
			Source: Sales Records
			
			
			
			
			
Average Sales by Dealership and Sales Representative Totals			
			
	Last Quarter v. Current Quarter		
	2018		
Dealership	#	Avg # Sales Per Person	Avg # Sales Per Person
Alan's Auto Shops	3	*	*
Barbara's Buick Dealerships	31	8.00	9.50
Cal's Chevrolet Dealerships	93	6.00	7.25
Danny's Dealerships	12	6.50	7.00
Frank's Ford Dealerships	4	*	*
All Dealerships	143	6.36	7.72
 			
			Source: Sales Records
			
			*Masked intentionally
 

The first table represents the data. The second table represents the data in how I wanted it masked. Basically, I'm looking to mask all columns except the first one if the value of the first one is less than five.

Any ideas?

Again, MASK might be an option or a defined field. I'd need to write nine fields or nine masks as the actual report has nine columns besides the # column. MISSING might be an option. I'm not sure though because the data is there, and I want to show that it's there. I just want to mask it somehow.

This message has been edited. Last edited by: FP Mod Chuck,

Masked from anybody who will access the data or only within this report result ?

As for option 1 you could use master file DBA option

As for option 2

SET NODATA = *

DEFINE FILE abc
SALES /P8.3 MISSING ON = IF SALES LE 5 THEN MISSING ELSE SALES;
END

or

TABLE FILE abc
SUM COMPUTE SALES /P8.3 MISSING ON = IF SALES LE 5 THEN MISSING ELSE SALES;
...
END

But it seems for me that it's a report result issue, so option 2 should be better.

You could use the dynamic formatting method such as -

TABLE FILE CAR
SUM COMPUTE FORMAT/A8 = IF MODEL CONTAINS 'AUTO' THEN 'I1' ELSE 'D20'; NOPRINT
    RCOST/FORMAT
    DCOST/FORMAT
 BY COUNTRY
 BY CAR
 BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
INCLUDE = warm, $
ENDSTYLE
END
-RUN

T

Thank you both for your replies.

Martin's code is very similar to code I used in the past for something else, and I was fairly certain it should work but I had to convince a colleague. I showed the solution to my colleague, and he was able to use it/modify it slightly for the challenge outlined in this post.

Thanks again.