Forum Discussion

Jameswh91's avatar
Jameswh91
Icon for Helper III rankHelper III
4 years ago

Net Margins with minus figures

Hi, i'm having issues with calculataing the net margin as my cost price is showing a negative figure. Is there a formula i can so a negative product quantity shows zero cost price?
Need Help
Show and Tell
samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
4 years ago

Are you wanting to do this in power query? if so a custom column with some like :

=if [margin]<0 then [cost price] else [margin]