Skip to main content
Question

How to handle the division of metrics by empty or null values?

  • November 3, 2025
  • 5 replies
  • 31 views

Forum|alt.badge.img

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:

 

 

5 replies

Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • 69 replies
  • November 3, 2025

Could you please check if the metric Discounts and Gross_Sales share the same dimensions?


Forum|alt.badge.img
  • Author
  • Apprentice Author
  • 7 replies
  • November 3, 2025

Hello, yes, it shares the same dimensions. Thank you for your help.

 


Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • 69 replies
  • November 3, 2025

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.
 

 


Forum|alt.badge.img
  • Author
  • Apprentice Author
  • 7 replies
  • November 3, 2025

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.

 


Min Li
Master Helper
Forum|alt.badge.img+12
  • Master Helper
  • 69 replies
  • November 4, 2025

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.