Calculation between entities

Your understanding is correct, but I wonder if the total line is actually zero. Since these are all members in the same entity, the total line is usually defined as a sum of other elements. If the total line is zero, then your rules won't work as designed. If this is the case, there are a few options.

Populate the total line with the correct total during your load process
Use something form the Nexel Complete Formulae library to make a calculation

I'm sure there are other ways to approach it, but these are just two that come to mind.

Good luck,

in addition to what Bob Gill already said, it would be helpful to have a screenshot of your dataview with and without the rule applied.

That would make it far easier to help you along.

Kind Regards,

Helmut

So here are my screenshots sorry for this black bar im not allowed to show any numbers..

the second column "%anteil an der Gesamtleistung 2011" should show the percentage amount of "Gesamtleistung= total output" for every member

but as you can see, with the rule as shown apllied it shows me 0 for everything..without a rule applied its just the same cube as I use for the first column "aktuell 2011"

Im pretty sure I missed something or did something wrong cause this should be easy

Bob Gill I do not really understand what you mean by that

Populate the total line with the correct total during your load process

Bob Gill and Helmut Heimann thanks a lot for your patience !

OK, do you have figures on all of the entity members (the column behind the black bar) and just want to calculate the percentile? Or, do you have figures for just a few members? That would be good to know in order to see if your rules are set up correctly.

Kind regards,

Helmut

Helmut Heimann , there is a value for each member behind the bar yes.

And I want to calculate the percentile

then, I suppose you don't need rules at all.

Put the cube into the layout a second time, set "refer to" to "Gesamtleistung", hide this block and calculate the percentage in an algorithm, that's it.

For more information look here: References tab

Kind Regards,

Helmut

Helmut Heimann, this is what I did before I started with rules.. but my result is this and I could cry a river

if you build up your dataview according to this (taken from the help page):

with all columns visible (it should look similar)--do you see figures in each cell?

Kind Regards,

Helmut

If you want to show the percentage with the help of entity calculation then you have to follow some step to achieve this.

please find the attached file for more details.

let me know if this fulfils your requirement.

Thank you.

Mukesh Rathod

Thank you Mukesh!

Where can I find this file?