Lines Matching refs:p
49 <p><b>Named Item</b></p>
51 <p>If a base item name is specified, the reference value for a combination of field items is the
52 result where the item in the base field is replaced by the specified base item.</p>
54 <p>If the reference value isn't shown in the DataPilot table because of hidden details for a
55 parent field, the difference isn't calculated and an error value is shown.</p>
57 <p>If the result for an item combination is empty, the value 0 is used for the difference, even
59 is shown in the result table even if the original result was empty.</p>
61 <p>The difference for item combinations containing the base item is shown as empty result.</p>
63 <p><b>Previous or Next</b></p>
65 <p>If "previous" or "next" is specified as the base item, the reference value is the result for
69 of previous and next items.</p>
71 <p>Empty results are handled as for named items (see above).<p>
73 …<p>The difference for the first (for <TYPE>com::sun::star::sheet::DataPilotFieldReferenceItemType:…
75 shown as empty result.</p>
86 … <p>Division by zero results in an error. Otherwise, empty results are shown as 0. Results for
89 as 1 if not empty.</p>
101 …p>Division by zero results in an error. Otherwise, the rules for <const scope="::com::sun::star::s…
111 <p>If details for one item in the base field are hidden, that item isn't included in
113 between details and subtotals for the following items.</p>
115 <p>Results are always summed, even if a different summary function was used to get each result.</p>
117 <p>Totals outside of the base field are shown as empty results.</p>
126 <p>If there are several data fields, the total for the result's data field is used.</p>
128 <p>If there are subtotals with manually selected summary functions, still the total with
129 the data field's summary function is used.</p>
131 <p>Division by zero results in an error.</p>
133 <p>Otherwise, empty results remain empty.</p>
156 <p>( original result * grand total ) / ( row total * column total )</p>
158 <p>Division by zero results in an error. Otherwise, empty results remain empty.</p>