I would like to divide my 'Discount_EUR' metric by my 'Gross Sales EUR' metric, but I'm not getting any value. Can you help me solve this problem? Thank you in advance.
Result:
Solved
How to handle the division of metrics by empty or null values?
+2- Author
Best answer by Jules R
I found an explanation for my problem; I just needed to use the following formula in my division calculation to get the correct result: Discounts_EUR /Gross_Sales_EUR [REMOVE SUM:SALES_Org,PRODUCT,CURRENCY,CUSTOMER,ACCOUNT,VERSION,Month]*100
+14- Master Helper
Could you please check if the metric Discounts and Gross_Sales share the same dimensions?
+14- Master Helper
What does this warning say? Or you may want to lay out the metrics at the very bottom level and make sure there are values from both metrics at the same intersection instead of the aggregation level.
+2- Author
I aligned all the Metrics with their s dimension so that Discount and Gross Sales have the same structure; I no longer get an error message, but this does not solve the problem.
+14- Master Helper
Now you have 7 dimensions in your final metric. In your metric of Discount_EUR, I noticed that the customer dimension is not included from your previous screenshot.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.