NO.41 In a calculated measure, when a denominator is null or zero, what symbol is displayed?
A calculated measure is a type of measure that is derived from an expression or formula based on existing measures or dimensions. You can use calculated measures to perform various calculations on your data, such as ratios, percentages, differences, etc. However, some calculated measures may result in errors or invalid values when the denominator is null or zero. For example, if you try to calculate the profit margin as (Profit / Revenue) * 100, and the revenue is zero, you will get an error. In such cases, SAP Analytics Cloud displays a symbol instead of a value for the calculated measure. The symbol that is displayed when the denominator is null or zero is # (hash sign). Therefore, the correct answer is #, as it is the symbol that is displayed when the denominator is null or zero in a calculated measure.
Verified Reference: Create Calculated Measures