Forum Discussion
Helper IIDivide negatives with positve
Hi,
I have a problem I hope some smart people here can solve! :)
Example:
| Store | Gross Margin result | Gross Margin Budget | Index Budget |
| New York | -266 | -529 | 50 % |
| Chicago | 360 | 155 | 232 % |
| Florida | -37 | -205 | 18 % |
| Alaska | -146 | -62 | 235 % |
| Total | -89 | -641 | 14 % |
If you look at New York, we're 50% below the budget loss, i.e index 150% positive index. How do I solve the 4 scenerios in Power BI when it comes to divide postives and negatives?
6 Replies
- dedelman_clng
Community Champion
What formula/logic are you using to get the "Index Budget" column currently?
Hi elkjoperik,
According to your description, the formula logic seems like original percent(100%) + (diff between Budget and result).
If this is a case, you can try to use below formula:
Result = 1+(1-[Index Budget])
In addition, if above not help, can you share some detailed information about the calculation?
Regards,
Xiaoxin Sheng
elkjoperikMany thanks for the replies.
I'm using "Gross Margin result" / "Gross Margin budget"
In my head, the results should be for Index Budget:
New York: 150%
Chicago: 232%
Florida: 18%
Alaska: 235%
Total: 720%
How to create a formula that solves the 4 scenarios you have:
1. Positive / positive
2. Positive / negative
3. Negative / negative
4. Negative / positive
Hi elkjoperik,
I still not clear how did you get the result "new york" = 150%, can you share some detail steps?
Regards,
Xiaoxin Sheng
