I have a set of data that has an ID, Start Date, End Date, and an Annual Cost. I need to create a view that shows how much should be allocated to each month year. I know I need to first calculate the cost per day, to allocate a certain amount per month, but after that I am not sure how to handle this since their are 2 date fields.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
