Three column calculations

Take the results of one calculation and use it in a second calculation. This makes it possible to use calculation results in deriving another calculation. Once you use one calculation in another calculation column, you cannot use that result in yet another calculation.  

For example, if Column A + Column B = Column C, and then Column C + Column D = Column E....the Column E results cannot be used in an additional calculation.

Example:

This schedule has three Values SmartColumns -- "Units Sold," "Price Each," and "Target Sales" -- and two Calculation/Indicator SmartColumns -- "Item Sales" and "Target vs. Actual."  

"Item Sales" multiplies "Units Sold" and "Price Each."  "Target vs. Actual" uses the calculation result in "Item Sales" and subtracts the "Target Sales" values.

 

 

Related Topics

  1. Calculate the difference between two milestone dates on a row with many milestones
  2. Calculation/Indicator SmartColumn options
  3. Calculation/Indicator SmartColumn: Display values as percent values and pies
  4. Calculation'Indicator SmartColumn: Display indicators based on values or text in

 

  

Guided Help Home

 

 

 

 

The fast easy way to schedule your projects:  Milestones Software by KIDASA Software, Inc. www.kidasa.com

Copyright © 2025 KIDASA Software, Inc. All rights reserved.