Select to confirm the changes to the column, the updated column will now ‘Ok’ be displayed within the selected columns pane. Save your analysis using the Analysis’ button, overwriting the previous ‘Save saved analysis. Editing a column to include a calculation within to show actual cost per Astro PU. Expand the Fields’ folder within the Subject Area and add an ‘Reporting additional Cost’ column to the Columns’. ‘Actual ‘Selected Select the icon for the additional Cost’ column, from the drop ‘cog’ ‘Actual down list presented select Formula’. The Formula’ pane will be ‘Edit ‘Edit displayed. Place your cursor at the end of the text in the Formula’ pane and ‘Column select the divide symbol (/) from the task bar at the bottom of the ‘Column Formula’ pane. Alternatively, you can simply type the symbol yourself. The symbol will be displayed within the Formula’ pane. Any ‘Divide’ ‘Column content added to the Formula’ pane will be highlighted, before ‘Column proceeding ensure that nothing in the Formula’ pane is highlighted. ‘Column Place your cursor at the end of the text in the Formula’ pane and ‘Column click followed by based Astro PUs’. This value will be used as ‘Column’ ‘Cost the second part of our calculation. At this point, we have taken the actual cost and divided this by the number of cost based Astro PUs. This is now a calculated column. As in the previous select the Headings’ option and amend the ‘Custom Heading’ to Cost per Cost based Astro PU’. Click to ‘Column ‘Actual ‘OK’ close the column formula window. The criteria should now show as below. Save your analysis using the Analysis’ button. ‘Save
Select ‘Ok’ to confirm the changes to the column, the updated column will now be displayed within the selected columns pane. Save your analysis using the ‘Save Analysis’ button, overwriting the previous saved analysis. Editing a column to include a calculation within to show actual cost per Astro PU. Expand the ‘Reporting Fields’ folder within the Subject Area and add an additional ‘Actual Cost’ column to the ‘Selected Columns’. Select the ‘cog’ icon for the additional ‘Actual Cost’ column, from the drop down list presented select ‘Edit Formula’. The ‘Edit Formula’ pane will be displayed. Place your cursor at the end of the text in the ‘Column Formula’ pane and select the divide symbol (/) from the task bar at the bottom of the ‘Column Formula’ pane. Alternatively, you can simply type the symbol yourself. The ‘Divide’ symbol will be displayed within the ‘Column Formula’ pane. Any content added to the ‘Column Formula’ pane will be highlighted, before proceeding ensure that nothing in the ‘Column Formula’ pane is highlighted. Place your cursor at the end of the text in the ‘Column Formula’ pane and click ‘Column’ followed by ‘Cost based Astro PUs’. This value will be used as the second part of our calculation. At this point, we have taken the actual cost and divided this by the number of cost based Astro PUs. This is now a calculated column. As in the previous select the ‘Custom Headings’ option and amend the ‘Column Heading’ to ‘Actual Cost per Cost based Astro PU’. Click ‘OK’ to close the column formula window. The criteria should now show as below. Save your analysis using the ‘Save Analysis’ button.