% of the sales weight

Question & Answer
, , ,
1

Hi !!!
I need to be able to divide the MRY of MX by the MRY of the US, to know the% of the sales weight of MX vs what the US sells

image
image1474×879 121 KB

I try this way but it gave me like result 1

image
image1307×199 4.85 KB

2

Hi @Geral ,

I would suggest to breakdown the calculation in 3 steps.
step 1: calculate US MRY
ifelse(marketplace=‘US’, MRY, NULL)
step 2: calculate MX MRY
ifelse(marketplace=‘MX’, MRY, NULL)
Step 3: calculate % of US MRY
sum(step2)/sum(step1) → change format to percentage

Once you test this calculation , you can combine them into a single calculation and use.

Thanks,
Prantika

3

@prantika_sinha thanks, it helped me too much :grinning: