5 Replies Latest reply on Jul 8, 2016 4:50 AM by Luciano Vasconcelos

# Previous Rolling 3 months from parameter- HELP

Hello All,

I have a quick question. On the attached, I'm trying to compute the utilization percentage for orders that went through our "EASy" order processing system.

With the help of this forum, I was able to create a "Current Rolling 3 months Utilization", which looks at the utilization percentage of the last 3 months based off my parameter.

Now, I need help creating a calculated field that would look at the "Previous Rolling 3 months Utilization". This would look at the next 3 months based off my parameter. To clarify, if my parameter was set at 1/31/2016, the "Current Rolling 3 months Utilization" would calculate for months November 2015, December 2015, and January 2016.

While the "Previous Rolling 3 months Utilization" would calculate the usage percentage based off August 2015, September 2015, and October 2015.

Any ideas on how to solve?

See attached.

Cheers,

Mikey

• ###### 1. Re: Previous Rolling 3 months from parameter- HELP

Mikey,

I haven't been able to get this to work quite right, but I"m thinking the calculated field for Previous 3 Month Utilization would be something like this:

then [EASy Utilization] end

What I wasn't able to do was apply the table calculation to ROWS in range like you did for current.  I thought maybe this would help though and you would be able to duplicate the calc part.

-Hope

• ###### 2. Re: Previous Rolling 3 months from parameter- HELP

I dis it but it's on 9.3 version.

Can you open it? If not i can do in 9.2.

• ###### 3. Re: Previous Rolling 3 months from parameter- HELP

Luciano,

You are very close, however I do not think this is 100% correct. For example, if I look at the source data, EMEA should be 75% Utilization. As you can see below, they had 9 "EASy" orders out of 12 total.

Cheers,

Mikey

• ###### 4. Re: Previous Rolling 3 months from parameter- HELP

Expressions are considering both edges as you can see below:

if attr([Month]) >= DATEADD('month',-2,[Date parameter]) and attr([Month])<= [Date parameter] then [EASy Utilization] end

Is that correct?

I didn't calculate EASy Utilization.

Check Display the value.

Is correct.

• ###### 5. Re: Previous Rolling 3 months from parameter- HELP

This is the correct one.

Check Sheet 3.

This field EASy Utilization is good just to use together Month field.

It's the full value.