Re: Transform to negative numbers

‎06-19-2017
06:35 AM

I think my query is similar so I am hoping you can help me!

I have a spreadsheet with 2 tabs:

- Cost

- Revenue

The cost tab has negative values (costs) and positive values (credits). The negative numbers (costs) are much higher so the SUM total is generally negative. I want to display the total (costs and credits) per product however because all but 3 end up being a negative number they don't display in my pie chart (only where SUM is positive do they show in the visualisaion). I hope this makes sense, please let me know if not or if you need anymore info.

Going on from this I will create a formula revenue-cost to calculate profit, so I think for this reason as well the Costs total needs to be positive?

Re: Transform to negative numbers

‎06-12-2018
10:00 PM

In today's episode, I talk with Ben Halpern. You may know him from his tweets as @ThePracticalDev. Ben also is the founder of dev.to, a site for developers to share knowledge and culture with one another.

Check out dev.to to learn a bit more about what Ben has created!

April 14, 2017

In today's episode, we'll be talking about a very simple shift for your emailing strategy.

April 12, 2017

In today's episode, we discuss Supui's question regarding how to stand out as an applicant. We reinforce some of the things we've discussed previously, and introduce some new ideas as well. Thanks to Supui for the question!

April 10, 2017

In today's episode, I answer listener Jonathan's question about getting ready for a baby, and simultaneously planning content.

April 7, 2017

In today's episode, we talk about hiring in a constrained scenario.

April 5, 2017

Today is Developer Tea's 365th episode!

In today's episode, we discuss some practical ways to get brainstorming jumpstarted.

Today's episode is brought to you by Linode. Linode Provides superfast SSD based Linux servers in the cloud starting at $10 a month. Linode is offering Developer Tea listeners $20 worth of credit if you use the code DEVELOPERTEA2017 at checkout. Head over to spec.fm/linode to learn more about what Linode has to offer to Developer Tea listeners .

April 3, 2017

In today's episode, I answer a listener question about behavioral patterns.

Today's episode is brought to you by Linode. Linode Provides superfast SSD based Linux servers in the cloud starting at $10 a month. Linode is offering Developer Tea listeners $20 worth of credit if you use the code DEVELOPERTEA2017 at checkout. Head over to spec.fm/linode to learn more about what Linode has to offer to Developer Tea listeners .

March 31, 2017

In today's episode, we'll talk about a mistake you may be making with your resumé (and how to avoid it).