column algorithm based on excluded cubes shows random values

Katharina Strebe
Katharina Strebe Customer
Second Anniversary First Comment
in Platform

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

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    Fourth Anniversary 250 Likes 100 Comments 5 Answers

    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
    Katharina Strebe Customer
    Second Anniversary First Comment

    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

Categories