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 References:
: Create Calculated Measures
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit