Forum Discussion
tobiasmcbride
Helper III
Helper IIIComparing headcount budget and actuals
Hi, I need to be able to compare 2 different datasheets of Headcount budget vs. actuals. The data format is as such: H/C Budget: Budget 31/01/2019 28/02/2019 31/03/2019 2017 Final ...
HI tobiasmcbride,
Maybe you can try to create a calculated table to store expand table records of each date of your date ranges and link to your original table. Then you can simply use table fields to summarise values:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng
HI tobiasmcbride,
Maybe you can try to create a calculated table to store expand table records of each date of your date ranges and link to your original table. Then you can simply use table fields to summarise values:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng