Running average, wh...
 
Notifications
Clear all

[Solved] Running average, what is the best way to set it up in Jedox ?

4 Posts
2 Users
0 Likes
154 Views
Active Member
Joined: 10 months ago
Posts: 6
Topic starter  

Running average, what is the best way to set it up in Jedox ?

Would it be via a hierarchy or via a rule setup ?

Would it be possible to advise on a rule setup on running average ? 

 


   
Quote
Jedox 4 Beginners
Trusted Member Admin
Joined: 3 years ago
Posts: 32
 

Hi Martin,

you can do it via rule. I am attaching a picture of how it can look.

 
SO whenever you add a number, the base day date average is recalculated.
I hope this is what your question was about.
This post was modified 9 months ago by Jedox 4 Beginners

   
ReplyQuote
Active Member
Joined: 10 months ago
Posts: 6
Topic starter  

Thank you for your solution. I was more looking for a generic setup, that can be used across all amount calculations, so within the time dimension. 

I have found a solution, supported by Time Editor, to generate Rolling Month setup as R03, R06, R09 and R12, see attached screen print

 


   
ReplyQuote
Active Member
Joined: 10 months ago
Posts: 6
Topic starter  

For the average part of R03, R06, R09 and R12, I was thinking of building that into the report directly dividing with value(right(month,2))


   
ReplyQuote
Share:

Join the Jedox4Beginners forum and engage with a community of passionate Jedox users. Get expert advice, share insights, and find solutions to your Jedox-related queries. Unlock the power of collaboration and accelerate your learning journey in the world of Jedox.

Join the Jedox4Beginners forum!