ConsolidatedAvg & UNDEFVALS

[HighKeys]

Hi Orlando!


thanks yes i know where i can find the weightings


So now i got the update installation done to version 2.0.8.

Edit: if you mean i could set the weighting to 30 or 31 i think it will not work here, cause i try to build an avg over the montly value
noooooooo. don't do that. that will not help.....

i'm afraid that you didn't get the point for what the weighting is for. you should read the documentation for TM1 (i think you got the links in one of your other threads)

sorry my mistake, totally crap what i wrote here... sure it would be nonsense to set it to 30 or 31, what i mean was in example 30 days month the weighting would be 0,033*

please do the following:
- update to PA 2.07 or better 2.08
- don't use UNDEFVALS in Rules
- don't use Zeroweightoptimization
- set the weightings for the elements you want to calc the avg for to 1
- check if you get trouble in other cubes this dimensions is used
- write the avg rule
- check the results

Done and works perfect!

Thank you

now i can remove much of this help elements in the cubes here (ghost counter elements to get average)

Thanks my friend!

[orlando]

Done and works perfect!

Hurray!

now i can remove much of this help elements in the cubes here (ghost counter elements to get average)

if you now get rid of the VBA and put the application on the web, then this is also something for the future

Thanks my friend!

you're welcome