1 Reply Latest reply on Jun 7, 2018 4:45 PM by Shinichiro Murakami

# Daily Average Percentage Difference within a Group

I try to estimate the daily average percentage difference of various products within a group.

Assume I have the data table below

Using table calculations, I was able to estimate the percentage difference of average price of a group, but not the average percentage difference of the products within a group.

The desired result looks like this

Group6/5/2018
6/6/20186/7/2018
G12.7% (2.7% / 1, it ignores p2 since value is NULL)10.12% ((2.24%+18%)/2)
G2-0.30% ((-1.42%+0.81%)/2)-1.40% ((0.72%-3.52%)/2)
• ###### 1. Re: Daily Average Percentage Difference within a Group

HI Stergios

In this case, you need nested table calculations.

(You can ctrl+drag the triangle pill to measure area.)

Then

Now you got the numbers but it is duplicated with number of products.

(You can not remove products because it's used for the calculation still).

Step.2

Thanks,

Shin

1 of 1 people found this helpful