Administrative functions > Creating and maintaining Quanvert databases > Secure databases > Treating data values as summary in secure databases
 
Treating data values as summary in secure databases
Quick reference
To instruct Quantum to use the raw count rather than the result of the calculation when deciding whether to suppress an n01 statement with an ex= expression in a secure Quanvert database, type:
;summary
after the ex= option on the n01 statement. If you want to do this for all ex= elements in the axis, place the summary keyword on the l statement.
More information
By default, in secure Quanvert databases, for n01 statements with an ex= expression, Quanvert calculates the expression and uses the result and not the raw count when determining whether the values in the row or column should be suppressed. If you want to use the raw count, instead of the result of the calculation, use the summary keyword on the ex= element.
For example, if you have the following:
l drinks
n01Coffee;c=c109'1'
n01Tea;c=c109'2'
n01Average;ex=(#1+#2)/2
then you would probably want the expression to be calculated for the special cells.
But, if instead, you had:
l drinks
n01Coffee;c=c109'1'
n01Tea;c=c109'2'
n01Difference;ex=#1-#2
the ex= here normally produces a small value. In this situation, you would probably want the qvsecure suppression check to be done on the number of cases belonging in the Difference cell, not on the value of the difference. To do this, use the summary keyword within the axis of the Quantum program as follows:
l drinks
n01Coffee;c=c109'1'
n01Tea;c=c109'2'
n01Difference;ex=#1-#2;summary
This indicates that the ex= for Difference produces a summary value, not a data value.
Note All the ex= elements in the above examples are n01 elements rather than m elements. This is essential for summary ex= elements.
Where an axis had a mixture of ex= type elements, some of which you would want to be treated as summary and some to be treated as data, you could write the axis as:
l drinks;summary
n01Coffee;c=c109'1'
n01Tea;c=c109'2'
n01Average;ex=(#1+#2)/2;nosummary
n01Difference;ex=#1-#2
n01Ratio;ex=#1*100/#2
where summary on the l statement indicates that, by default, all ex= elements in the axis are summary elements, while nosummary on the Average element overrides this for just this element.
See also
Secure databases