The following sections discuss each of these morph operations.
This operation adds a fixed value to each cell. If you want to subtract, use a negative number.
This operation multiplies each number by a fixed amount.
This operation multiplies each number by a percentage.
This operation adds another numeric field to the data source. This example in an airport database calculates the altitude above sea level of each airport’s traffic pattern.
This operation subtracts another numeric field from the data source. This example from a real estate listing database calculates the price change from the original listing to the curent price.
This operation multiplies the data source by a numeric field.
This operation divides the data source by a numeric field.
For more complex calculations you can use a formula. You can use a formula all on its own (see Morph Field Dialog) but you can also use a formula in combination with other manipulations. When used this way, the
«◊» symbol will expand into the number produced by the previous manipulations. Then the result of the formula will be fed into any additional calculations below it.
This example calculates the age of a property in a real estate database, based on a field that contains the year the property was built.
|10.0||No Change||Carried over from Panorama 6.0|