cancel
Showing results for
Did you mean:
Regular Visitor

Negative data after a certain date

Hi,

I have an issue that I am not sure how to solve.

The report consist of two dates: expiry date and start date and I have a number of employees per team in a column.

The issue is that I am not sure how to present the numbers of employees when they have exceeded the expiry date.

EG.

Start date 01-01-2018: 5

Expiry date 01-10-2018: -5

How do I change it to be -5 after the expiry date?

4 REPLIES 4
Super User

Re: Negative data after a certain date

@JimmyDQN Could you please explain bit more detail (It will be great if you can provide sample data to test). As per my understanding you need to turn the number into negative value after a particular date ? If that's the case just multiply with "-1" to your value. Sample data and expected output will be helpful to provide an accurate solution.

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Regular Visitor

Re: Negative data after a certain date

Hi,
I have inserted an example below. I would like a visualization where the axis is based on months. and then I want
January to have number of members for each team. So for january it would be 105 + 55 + 56 whereas february will show current members (55 + 65 + 45) but also show how many we lost. If you need I can try to make an example in Excel.

 Team Contract Country År Contract Start Date End date 1 105 DKK 2018 jan Feb 2 55 DKK 2018 jan Feb 3 56 DKK 2018 jan Feb 1 65 DKK 2018 feb Mar 2 55 DKK 2018 feb Mar 3 45 DKK 2018 feb Mar 1 123 DKK 2018 mar Jul 2 123 DKK 2018 mar Jul 3 45 DKK 2018 mar Jul 1 43 DKK 2018 jul dec 2 23 DKK 2018 jul dec 3 5 (tom) 2018 jul dec
Super User

Re: Negative data after a certain date

@JimmyDQN Yes please, It will be helpful if you can post the expected output as well.

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Regular Visitor

Re: Negative data after a certain date

@PattemManohar I just made a better example:

I would like to create a bar chart based on date.
In January, product 1 will be positive as the contract has not expired, but in the following month, i want that data to be negative, as we have "lost" that money.

 Product Team Owner Country År Contract Start Date Contracts starting revuune while contract is active Product 1 Person A DKK 2018 jan-18 feb-18 500 Product 2 Person A DKK 2018 feb-18 mar-19 640 Product 3 Person A DKK 2019 mar-18 apr-18 251 Product 4 Person A DKK 2018 apr-18 maj-18 268 Product 5 Person A DKK 2018 maj-18 jun-19 656 Product 6 Person A DKK 2018 jun-18 jul-18 2418 Product 7 Person B DKK 2018 jul-18 aug-18 21 Product 8 Person B DKK 2018 aug-18 sep-19 298 Product 9 Person C DKK 2018 sep-18 okt-18 2047 Product 10 Person C NO 2018 okt-18 nov-18 22117 Product 11 Person D DKK 2018 nov-18 dec-19 26287 Product 12 Person F NO 2018 dec-18 jan-19 2154 Product 13 Person F DKK 2018 jan-19 jan-19 2356 Product 14 Person D DKK 2018 feb-19 mar-19 2998