Welcome Guest! To enable all features please Login or Register.
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.


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,

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: 183

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.

Best regards

Páll, CTS
Users browsing this topic
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.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.