column algorithm based on excluded cubes shows random values

Katharina Strebe

Dear all,

 

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.

if(e=0,0, (b-e)/b*100)

 

Thank you in advance

 

Kind regards Katharina

Alexander Kappes

Dear Katharina Strebe,

 

for me it looks like that some rows for block e are empty. For this division by zero isn´t defined.

 

Please switch your algorithm to:

 

if(b=0,0, (b-e)/b*100)

 

What do you mean with random values in detail? Do you have a screenshot which explains the problem a little better?

 

let me know

 

regards

 

Alexander Kappes

Katharina Strebe

Dear Mr. Kappes,

 

thank you for your response.

We`ve changed the if-clauses and now it works.

Before it showed the value "100%" in every row. 

 

Kind regards from Höxter

Katharina Strebe