Report Portal

Average Monthly calculations

You'll often be tempted to build a CASE WHEN Level calc to get an average monthly calc, but there's an better way.

You'll notice the error when using CURRENTMember and in the client tool doing a multi-select, it doesn't work because it doesn't have a single member to work against - this solution fixes this

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.