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:

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:

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

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.