Add Calculated Column for Cost Per Unit in report

Post Reply
M1EnterpriseTech
100 Club: Active Contributor
100 Club: Active Contributor
Posts: 171
Joined: Wed Aug 24, 2016 9:22 am

Add Calculated Column for Cost Per Unit in report

Post by M1EnterpriseTech »

To add a calculated column to show a Cost Per Unit amount as a new column in the Inventory Dead Stock report go to:
  • Reports from the home ribbon
  • All Reports from left panel
  • Inventory
  • Inventory Dead Stock - double click to open
  • Execute from ribbon
  • Calculated Columns from ribbon
  • Column Name = type Cost Per Unit
  • Column Header= type Cost per Unit
  • Data Type = System.Int32 ( If not already entered, select using drop down arrow)
  • Format = Leave blank
  • In the Formula window type exactly as you see here in yellow font: [Cost]/[Quantity]
  • Click Add button
  • Click Ok
You will now see a new column in your Inventory Dead Stock report called Cost Per Unit with Cost divided by Quantity Total
Enterprise Support Specialist
Post Reply

Return to “Enterprise: Reports”