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

1 Reply

  • 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]