On Thu, Jun 22, 2023 at 1:00 PM Wetmore, Matthew (CTR) <Matthew.Wetmore@xxxxxxxxxxxxxxxxxxx> wrote:
Hi, I have this issue and now I’m just wasting time. Can you tell me what I’m doing wrong?
Like the error message says - you are trying to use a generated _expression_ when one of the inputs is volatile (or, is not immutable).
It makes no sense to store "hours elapsed" when the concept of current time (an ever changing concept) is being used in the formula. Create a view with you _expression_ then the view can always provide an accurate value for elapsed time as of when the query is run.
David J.
