Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Sylvain Roy  
#1 Posted : Tuesday, February 6, 2018 8:46:22 PM(UTC)
Sylvain Roy
Rank: Newbie

Groups: extranet\Forum
Joined: 9/5/2017(UTC)
Posts: 3

We are using the openbal and closebal functions to create measure for beginning inventory and closing inventory, by period.

Our dates are in a hierarchy that groups day into weeks, then month and then year.

We would like to be able to average the opening balance of a month with the daily value of the balances. I.e., the average for a week would be the sum of the balance of the 7 days divided by 7.

Can this be done with the Analysis tool (using the avg function) ? Or the Data model ?

Thanks in advance for any input.
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.