Forum Discussion
Help 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...
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
Gladly... 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.
Best option is to upload to a cloud service (Onedrive, Google Drive, iCloud, Dropbox...) and share from there..
Thanks... the file should be available here https://drive.google.com/file/d/1SwIy0sPVGAxkIrXT54j6Ff3RAeRzbe2O/view?usp=sharing