The Formula Workshop, available in the Help menu, lets you quickly test formulas and perform calculations.

Formula results are calculated immediately as you type, there is no need to press Return or Enter.

Any type of formula can be used, including formulas that work with numbers, text, dates or boolean values.

Multiple Formula Workshops

Click the green arrow to open a second workshop window.

You can open as many workshop windows as you like. They are all independent of each other, so each one can have a different formula.

(Tip: If you hold down the Option key when you click on the green arrow, the new window will start out with a copy of the formula in the previous window, which you can then edit as needed. This makes it easy to test out different variations on a formula.)

Custom Display Format

The wizard automatically displays numbers and text. If your formula produces some other type of value, you can use the Format menu to format it for you. For example, the now() function returns an integer value, but it makes more sense to display this integer in time format (hh:mm:ss).

Refreshing the Calculation

If you need the calculation to refresh without typing, press Result or the refresh arrow (circular arrow).

Use the refresh for formulas with functions that might change over time, like now(), info(“files”), rnd(, etc)

Linking to a Database

If you link the workshop to a database, you can use database fields and fileglobal variables in the formula. Note: You cannot use local or windowglobal variables in the workshop.

See Also


10.0UpdatedCarried over from Panorama 6.0, completely new interface.