cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JimmyDQN Regular Visitor
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
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 !





JimmyDQN Regular Visitor
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. 

TeamContract CountryÅrContract Start DateEnd date
1105DKK2018janFeb
255DKK2018janFeb
356DKK2018janFeb
165DKK2018febMar
255DKK2018febMar
345DKK2018febMar
1123DKK2018marJul
2123DKK2018marJul
345DKK2018marJul
143DKK2018juldec
223DKK2018juldec
35(tom)2018juldec

 @PattemManohar

Super User
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 !





JimmyDQN Regular Visitor
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. 

ProductTeam OwnerCountryÅrContract Start DateContracts startingrevuune while contract is active
Product 1Person ADKK2018jan-18feb-18500
Product 2Person ADKK2018feb-18mar-19640
Product 3Person ADKK2019mar-18apr-18251
Product 4Person ADKK2018apr-18maj-18268
Product 5Person ADKK2018maj-18jun-19656
Product 6Person ADKK2018jun-18jul-182418
Product 7Person BDKK2018jul-18aug-1821
Product 8Person BDKK2018aug-18sep-19298
Product 9Person CDKK2018sep-18okt-182047
Product 10Person CNO2018okt-18nov-1822117
Product 11Person DDKK2018nov-18dec-1926287
Product 12Person FNO2018dec-18jan-192154
Product 13Person FDKK2018jan-19jan-192356
Product 14Person DDKK2018feb-19mar-192998