1 2 Previous Next 15 Replies Latest reply on Oct 9, 2018 2:23 PM by NAYANA MADHEKAR

How do I get an Average?

When I do Last()=0, its adding all 3 weeks, which is right. But I need an average. how do I do that? Average of the last 3 columns three?

My Formula is :

IF

DATEDIFF('month',ATTR([Wk Ending Date]),ATTR(TODAY()))=0

and

ATTR([Wk Ending Date])<=ATTR(TODAY())

THEN

[Sales]

ELSE 0

END

(Sales formula -> Sum(Gross Units)/Sum(Net units))

It doesn't let me do Total compute -> Average. (The result is attached in a photo).

Thank you !!!!

• 1. Re: How do I get an Average?

Use window average here

Thanks,

Ritesh

Please mark the answer as HELPFUL and CORRECT it it has really helped you so that it can help others as well

1 of 1 people found this helpful
• 2. Re: How do I get an Average?

It should have been (278 +280+295)/3 = 284 %

But instead window_Avg is giving me 24%. Why would that be? Am i missing anything?

• 3. Re: How do I get an Average?

Do you have workbook?

1 of 1 people found this helpful
• 4. Re: How do I get an Average?

Hi Deepak!!

Thanks for helping, I have attached workbook in the original post (if you scroll up).

I need Previous Week Column & Month to date (all the weeks in the month of September).

Thank you.

• 5. Re: How do I get an Average?

I am not able to get what u need from this view..Would you enlighten me?

• 6. Re: How do I get an Average?

I need the following view in the same sheet:

Columns:

Market | Attach Rate for most recent week | Attach Rate for Month to Date

Therefore I have those formulas

Previous week & MTD

• 7. Re: How do I get an Average?

The attachment is just a dummy set.

• 9. Re: How do I get an Average?

Deepak Deepak Should I expect to see you at the #TC18?

• 10. Re: How do I get an Average?

Should I expect to see you at the #TC18?

• 11. Re: How do I get an Average?

Yes

• 12. Re: How do I get an Average?

That's so exciting, Looking forward to meet you in person!

• 13. Re: How do I get an Average?

Do you have a Twitter Handle I can follow?

• 14. Re: How do I get an Average?

I do have..But I am yet not active..Have plans Though to be an active user.

1 2 Previous Next