en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Kevin Kuijsten  
#1 Posted : Thursday, December 12, 2013 1:43:08 PM(UTC)
Kevin Kuijsten
Rank: Member

Groups: extranet\Forum
Joined: 12/2/2013(UTC)
Posts: 6

Hi guys,
I'm trying to find out how it is possible to calculate the Average per item per store.

UserPostedImage

So what i'm trying to do is to get the AVG of the [Amount PO] per item per vendor if that's possible?
But i'm not sure if it's possible and what I need to do to get it done.

Kind Regards,

Kevin
Páll Bjarkason  
#2 Posted : Thursday, December 12, 2013 4:37:27 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi Kevin

There is an average function in calculations. Using the siblings (s) parameter you can get the desired result.

In the screenshot two custom calculations are added "as a measure" computing average. One calculation uses the siblings (s) parameter and the other only states all.


UserPostedImage
Best regards

Páll, CTS
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error