some of our salesman aren`t allowed to see margin. Therefore we`ve excluded the margin cubes in database security.
This works very well.
But, if we`re using this margin cube in a column algorithm it shows random values/ 100%.
Here the example:
Cube b= AE VK (orders retail price)
Cube e= AE EK (orders purchasing price- this cube is excluded)
(b-e)/b*100 (margin in %)
As the result of this column algorithm it shows 100%
We`ve tried to manage this Problem with an "if clause" but it doesn`t work either.
Thank you in advance
Kind regards Katharina