Division wrong output -- Results of division are multiplied by 4

shuwenf
shuwenf
in Modeling

shuwenf_0-1634954883013.png

Has anyone else encountered this problem? Tried using both DIVIDE(x, y) and x / y, results are always multiplied by 4. Odd Division Output 

Tagged:

Answers

  • anand.shekhawat
    anand.shekhawat

    @shuwenf 

     

    What I feel is you are looking the result at the parent level and the summary is set to SUM. And that particular parent is having 4 children.

    Anaplan might be calculating the 6/3 as 2 only. But at the summary level 2 is getting added 4 times(assuming 4 children) which results 8 as your output.

    Correct me if my intuition is wrong. 

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Categories