How to display a date calculation globally on hosted database?
Many thanks in advance.
I am trying to make a system to calculate how many minutes per day need to be written (by a composer) based on a date of completion and today's date. In other words, say the date the project needs to be done by is May 1st and there are 90 minutes left to write. I already have a field that calculates minutes yet to be written ("Total_unwritten") but I need the new component to calculate the current value of Total_unwritten divided by the amount of days existing between today and the completion date and express it in minutes.
I think I managed to do the calculation correctly:
days_left = (date_of_completion - Get(CurrentDate))
minutes_per_day = (Total_Unwritten / days_left)
So my question is, how do I make this a global value in a hosted database? I want to display it in the header and have it not tied to only one record.