🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Net Income in brackets in Excell

Net Income in brackets in Excell


Hi! I don’t get why you say that numbers of Net Income are the same in the table and after checking.
If I got that wright, when number is in brackets, it is negative and vice versa. Therefor Net Income numbers are different. In the new table it is positive (we got profit) but in Data Base they are negative (we lost something 🙂
Could you please explain in to me? Where am I wrong?

1 Answer

365 Team

Hi Aleksandr!
Thanks for reaching out and great to have you here.
The idea is that we do the following.

  1. We use SUMIF to transfer the P&L figures from the source sheet.
  2. In the source sheet, we have Net income (the extraction from the ERP system gave us this number too).
  3. We know that the bottom line result of the P&L is Net income
  4. When we transfer Net income through SUMIFS and we give it a negative sign, we can expect a check of 0 (Net income – Net income =0) 

Hope this helps!
Feel free to ask me an additional question if you need to.

Can you elaborate more on the difference of the ‘Net Income’ from the database and the P&L sheet in terms of losing money/gaining money? I don’t understand why both are the opposite sign.

4 weeks