Forum Discussion

radoslavov91's avatar
radoslavov91
Regular Visitor
1 year ago
Solved

Calculate percentage difference

Hi all, I've reviewed many posts, and tried ChatGPT but I could not solve this problem that I have. 

 

I have two measure columns: Total Opportunities Won and Total Opportunities Lost. I've created a column

OpportunityDifferenceWholeNumber to show the difference between both, which works great. 

In the report, we can see the trend between both. 

I want to be able to show the difference but in percentage instead as whole number. In this case the difference netween both values  is around 73%

Here the difference is 46%

 

How to achieve that. 

 

Thank you in advance for assisting me with this.

Need Help
  • Dangar332's avatar
    Dangar332
    1 year ago

    Hi, radoslavov91 

    General way to find diffrence in term of % is like
    A = 50
    b = 25
    ((a-b)/b)*100

    So yo can try below measure 

     

    % Measure =
var Total_won = [Total Opportunities Won] 
var Total_Lost = [Total Opportunities Lost]
return
divide(Total_won  - Total_Lost,Total_Lost)

     


    and convert you measure format to % so here you don't need to multiply by 100
    select measure and go to measure tool and select % symbol and your measure format converted to %

     

     

    Best Regards,
    Dangar

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    1 year ago

    Hi, radoslavov91 

    General way to find diffrence in term of % is like
    A = 50
    b = 25
    ((a-b)/b)*100

    So yo can try below measure 

     

    % Measure =
var Total_won = [Total Opportunities Won] 
var Total_Lost = [Total Opportunities Lost]
return
divide(Total_won  - Total_Lost,Total_Lost)

     


    and convert you measure format to % so here you don't need to multiply by 100
    select measure and go to measure tool and select % symbol and your measure format converted to %

     

     

    Best Regards,
    Dangar

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi radoslavov91 ,

    To calculate the diference between won and lost you can use this measure:

    OpportunityDifferencePercentage = 
DIVIDE(
    [Total Opportunities Won] - [Total Opportunities Lost],
    [Total Opportunities Lost],
    0
)

     

    Make sure to format the measure as percentage.

     

    Note: in your example all values are positive, is that correct? I mean, in the first example 155-82=73 what is great, in the second example should not be 20-32 what will result in -12?