This is another observation that isn’t necessarily earth-shattering, but potentially very useful in the right situation.

You can make calculated columns based on other calculated columns.

The example I’ll give will be pay rate per hour. Make a column that collects that information from the end user.

Then, make a calculated column based on the first column, multiplying it by 8 for how much they would make in an 8 hour day.

Make yet another calculated column based on the second, multiplying that by 5 for the week.

And a third calculated column multiplying that by 52 to get a year.

Add a fourth to divide 1 million by the value of the third calculated column, to figure out how long it would take to earn a million dollars.

You can then find out that at $15 per hour, 8 hours a day, 5 days a week, and 52 weeks a year, I can make a million dollars in a little over 32 years.  That is, as long as I pay no taxes, eat nothing, spend nothing, and am homeless.

Perhaps I need a raise?

In Summary: You can base calculated columns on other calculated columns.