How to combine 2 MDX formulas ?

Discussion in 'Performance Tuning and Optimization' started by gyvert, Feb 15, 2016.

  1. gyvert


    Feb 15, 2016
    Likes Received:

    I am trying to combine the 2 following MDX formulas in a single one: divide and sum.
    I have therefore created the following formula to get a ratio but it doesn't give me the correct result:

    divide([Profitability Total].[Profitability Total].[PL115-1TO - CHARGES SOCIALES],sum([Profitability Total].[Profitability Total].[PL105-4TO - SALAIRES DIRECTS],[Profitability Total].[Profitability Total].[PL105-8TO - SALAIRES INDIRECTS]))

    The figures for the formula are the following :
    PL105-4TO - SALAIRES DIRECTS : 5 331 906
    PL105-8TO - SALAIRES INDIRECTS : 672 459
    PL115-1TO - CHARGES SOCIALES : 1 686 010

    The current formula gives me a ratio of 250,7% when it should give 28,1%.

    Could anyone help me telling me what's wrong in my formula ?

    Thanks for your help
    gyvert, Feb 15, 2016
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.