Formula missing a value field to make calculation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am having an issue with formula that adds all of the value for each column from previous days. A column is not created since data was not generated for a previous day. For example, I have a calculation that totals the time of all the fields such as Lunch time, Training time, Documentation time, Gym time, and Sleeping time. The issue is that some days we don't generate a time for a particular field which wont allow my calculation to run. How to ensure my total time calculation runs if one of these filed didn't generate time for the pervious day.
FORMULA Tool:
Lunch Time + Documentation Time + Gym Time + Sleeping Time = Total Time
Note* Sleeping Time will become grayed out
(Sleeping time didn't generate data for the previous day . How to ensure it runs even if sleeping time didn't generate or any of the the categories not creating field)
Date | Lunch Time | Documentation Time | Gym Time |
2022-04-21 | 0.009826 | 0.044144 | 1.994491 |
Sleeping Time didn't generate a column since there's was no Sleeping generated for 2022-04-21 which will not allow my formula with all the categories to run.
Any assistance will be appreciated.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
