Hello All,

I’m currently trying to create 3-month trailing average for multiple dimensions. The formula worked when I only have 1 version dimension but when I tried to create multiple versions, it collapse.

Here is my metrics before adding version

Metric 1: Trailing 3 months (Boolean)

Metric 2: Trailing 3 months calculation

So, you can see Aug 25 is the trailing average for May through Jul

Here is what I attempted to replicate after adding version as a dimension.

Version Dimensio

Period Type by Month (by version)

Create a new 3-month trailing boolean for each version

But when I replicate the output, this error popped up 

Any help would be appreciated!

Thanks!