Forum Discussion
artfulmunkeey
Helper I
Helper IHelp with time intelligence and calculations
Hi all, back again for some much needed help! I am strugglign with the following problem and wonder if anyone can advise? I have the following tables; Total remainng Hours by month and Actual...
PaulDBrown
Community Champion
Community Champion
Can you provide a sample/dummy dataset to play around with?
Also, how do you calculate remaining dates? is it "working days" (exclude weekends and festivities)? If so, you will need to flag these in your date table
artfulmunkeeyHelper I
Helper IGladly... how do I do so? I have an excel with the two test data sets, would this do? I can't seem to upload it here.
- PaulDBrown
Best option is to upload to a cloud service (Onedrive, Google Drive, iCloud, Dropbox...) and share from there..
- artfulmunkeey
Thanks... the file should be available here https://drive.google.com/file/d/1SwIy0sPVGAxkIrXT54j6Ff3RAeRzbe2O/view?usp=sharing
- PaulDBrown