Skip to content
You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
You are viewing the article in preview mode. It is not live at the moment.

Showing articles from Formulas tag

  • How Is Gain Loss Calculated?

    The Gain/Loss Column within the Actual Cost grid is calculated as follows: When Period Qty=0, Gain/Loss = (-Period Cost); Otherwise, Gain/Loss = (Forecasted Unit Cost - Period Unit Cost) x Period Quantity When ToDate Qty=0, Gain/Loss = (-ToDate Cost); Otherwise, Gain/Loss = (Forecasted Unit Cost - ToDate Unit C…