Forum Discussion
New Row With Calculated Values
Hi, So, I'm trying to build a table with the company name, date, the number of accidents (and other variables, but let's simplify) and a calculated formula between the 2 dates I select (for which...
Anonymous , Not very clear. Can you share sample data and sample output in a table format?
Sample data:
Company Date N accidents Days off A 01/01/2017 2 15 A 01/02/2017 4 27 A 01/03/2017 4 27 A 01/04/2017 4 27 A 01/05/2017 4 27 A 01/06/2017 4 27 A 01/07/2017 4 27 A 01/08/2017 4 27 A 01/09/2017 4 27 A 01/10/2017 4 27 A 01/11/2017 4 27 A 01/12/2017 4 27 A 01/01/2018 0 0 A 01/02/2018 0 0 A 01/03/2018 0 0 A 01/04/2018 0 0 A 01/05/2018 0 0 A 01/06/2018 0 0 A 01/07/2018 0 0 A 01/08/2018 2 17 A 01/09/2018 2 17 A 01/10/2018 2 17 A 01/11/2018 2 17 A 01/12/2018 2 17 A 01/01/2019 0 0 A 01/02/2019 0 0 A 01/03/2019 0 0 A 01/04/2019 0 0 A 01/05/2019 0 0 A 01/06/2019 0 0 A 01/07/2019 1 0 A 01/08/2019 1 0 A 01/09/2019 1 0 A 01/10/2019 2 0 A 01/11/2019 3 0 A 01/12/2019 4 0 A 01/01/2020 0 0 A 01/02/2020 1 0 A 01/03/2020 2 0 A 01/04/2020 2 0 A 01/05/2020 2 0 A 01/06/2020 2 0 A 01/07/2020 3 0 B 01/01/2017 0 0 B 01/02/2017 0 0 B 01/03/2017 0 0 B 01/04/2017 0 0 B 01/05/2017 0 0 B 01/06/2017 0 0 B 01/07/2017 1 5 B 01/08/2017 1 5 B 01/09/2017 1 5 B 01/10/2017 1 5 B 01/11/2017 1 5 B 01/12/2017 1 5 B 01/01/2018 0 0 B 01/02/2018 0 0 B 01/03/2018 0 0 B 01/04/2018 0 0 B 01/05/2018 0 0 B 01/06/2018 0 0 B 01/07/2018 0 0 B 01/08/2018 0 0 B 01/09/2018 0 0 B 01/10/2018 0 0 B 01/11/2018 0 0 B 01/12/2018 0 0 B 01/01/2019 0 0 B 01/02/2019 0 0 B 01/03/2019 0 0 B 01/04/2019 0 0 B 01/05/2019 0 0 B 01/06/2019 0 0 B 01/07/2019 0 0 B 01/08/2019 0 0 B 01/09/2019 0 0 B 01/10/2019 0 0 B 01/11/2019 0 0 B 01/12/2019 0 0 B 01/01/2020 0 0 B 01/02/2020 0 0 B 01/03/2020 0 0 B 01/04/2020 0 0 B 01/05/2020 0 0 B 01/06/2020 0 0 B 01/07/2020 0 0 C 01/01/2017 0 0 C 01/02/2017 1 12 C 01/03/2017 1 12 C 01/04/2017 1 12 C 01/05/2017 1 12 C 01/06/2017 1 12 C 01/07/2017 1 12 C 01/08/2017 1 12 C 01/09/2017 1 12 C 01/10/2017 1 12 C 01/11/2017 1 12 C 01/12/2017 1 12 C 01/01/2018 0 0 C 01/02/2018 2 2 C 01/03/2018 4 10 C 01/04/2018 5 17 C 01/05/2018 5 17 C 01/06/2018 5 17 C 01/07/2018 5 17 C 01/08/2018 5 17 C 01/09/2018 5 17 C 01/10/2018 5 17 C 01/11/2018 5 17 C 01/12/2018 5 17 C 01/01/2019 0 0 C 01/02/2019 0 0 C 01/03/2019 0 0 C 01/04/2019 0 0 C 01/05/2019 0 0 C 01/06/2019 0 0 C 01/07/2019 0 0 C 01/08/2019 0 0 C 01/09/2019 0 0 C 01/10/2019 0 0 C 01/11/2019 0 0 C 01/12/2019 0 0 C 01/01/2020 0 0 C 01/02/2020 1 0 C 01/03/2020 1 0 C 01/04/2020 1 0 C 01/05/2020 1 0 C 01/06/2020 1 0 C 01/07/2020 1 0 Desired output:
Company Date N accidents Days off A 01/12/2018 2 17 A 01/12/2019 4 0 A ∆ 100 - B 01/12/2018 0 0 B 01/12/2019 0 0 B ∆ - - C 01/12/2018 5 17 C 01/12/2019 0 0 C ∆ - - I think I'm trying to achieve a pretty reasonable thing here...