Hi everyone,
I need to calculate the yearly contract amount based on start and end date as the example below:
Database would look similar to this:
And expected result like this:
Thanks in advance!
good morning
This is an example of the 2 date problem - typically solved using a date scaffold to create a single continuous calendar - not difficult just a few steps - see https://jimdehner2.blogspot.com/2019/12/use-scaffold-to-solve-2-date-problem.html the post includes step by set instructions - also see https://public.tableau.com/profile/jim.dehner#!/vizhome/scaffold-2dateexample/Overview for a downloadable workbook that can be used as a model
it returns this
If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote.
Also please help use better track your reply by including a mention to the volunteer who provided the answer – mine is @[Jim Dehner]
Thank you.
Jim
