Databases Reference
In-Depth Information
Of course, using this method relies on the expressions being
entered identically in all places with no spaces out of place.
In reality this will not always be the case, you may have to
perform a more generic search and perform some manual
editing instead of using the
Find/Replace
option.
If everything went well, you should be able to see the updated expressions for the
Performed vs Scheduled
gauge chart on the
Dashboard
sheet.
Now that we've seen how to create a new variable and how to retroactively update
hard-coded expressions to variables, it is left as an optional exercise to you, the
reader, to update the remaining expressions. The rest of this chapter will reference
the variables names, but you can also use the expression; the result will be the same.
