Forum Discussion

mjonesjr8's avatar
mjonesjr8
Frequent Visitor
4 years ago
Solved

Net amount based on 2 columns

I am pretty new to PBI,  This was in Excel, how can I get the samething in Power BI?   Thanks!     Over/Short Amount O  $5.00 S ($5.00) O $0.23 O $19.99 S ($20.00) S ...
Need Help
  • mjonesjr8's avatar
    mjonesjr8
    4 years ago

    Thanks for the reply but i'm not sure that will work.  It needs to add up all the numbers and then subtract out the (S's short)amount to get the net total.  

  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi mjonesjr8 

    As you already has negative values, sum  of amount will give 120. 

    Thanks

    Hari

Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi mjonesjr8 

As you already has negative values, sum  of amount will give 120. 

Thanks

Hari

mjonesjr8's avatar
mjonesjr8
Frequent Visitor
4 years ago

Thank you very much!