Forum Discussion
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
Anonymous 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.
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 Anonymous Yes please, It will be helpful if you can post the expected output as well.
