Forum Discussion
Anonymous
6 years agoNot applicable
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.
| Value | Percentage % | |
| Profit | € 584.531 | 100% |
| Salary cost | € -467.074 | -79,91% |
| Result | € 117.457 | 20,09% |
Not sure, seems to work for me:
2 Replies
- Greg_DecklerCommunity Champion
Not sure, seems to work for me:
- AnonymousNot applicable
Hi, I thougt that it was required to add an alternative in the function. Thank you for your reply!