Tuesday, January 27, 2009

Metric and Imperial Areas in Schedules

Here's a quick tip on how to create a schedule to show the same information but use different units of measure. I've been pondering whether this was too "simple" to post, but it did have me scratching my head for a while yesterday! After all I'm allowed to post newbie tips too ;) At first I thought I might have to place two schedules side by side, but as we shall see, it's not necessary.

Start by creating a room schedule and add the fields you want. Let's say you added Area and you left the units to use project settings, which are typically Imperial for us in the US (it's about time we move to metric!). Now what if I want another column to list the Area once again but in different units? Once we move the Area field from the "Available" column to the "Scheduled" column, we cannot add it again. So how do we get around this?

The answer is simple: create a calculated value. Don't get stuck thinking that this is just used for complex formulas. This can be as simple as being equal to another parameter. So simply type in "Area" as the formula, give it a name (such as Area_M) and you're set. Now go to the Formatting tab, select the newly created calculated value and change the units by clicking the Field Format button. This technique can also be used for length parameters or anything else that can be reported with different units.




Paula said...

I've spent a whole afternoon trying to get around this!

Anonymous said...

This kind of tip is actually far more useful and helpful than all of the 'advanced', impressive, power user stuff that is normally posted on blogs...

It's this kind of little trick that people don't know about!

Dave Baldacchino said...

I'm very glad you found it useful :) I'll keep my thinking hat on for more tips like this one.

Post a Comment