Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divide negative number

Hi Power BI users,

 

I would like to divide a negative number. Thus, below in my example I would like to see a column for every row a percentage where I divide  e.g. salarycost/profit = -79,91%. I have used the Divide function, but this won't give me the result below. The normal divide / is also not working. Is there an alternative where I could see my percentage negatively back?

 

Thank you instead.

 

 ValuePercentage %
Profit €   584.531100%
Salary cost € -467.074-79,91%
Result €   117.45720,09%

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, I thougt that it was required to add an alternative in the function. Thank you for your reply!