Page History

611. Click on the + button in the Sub Query panel to the left of the Data step to add a Sub Query.

712. Set the Type to Union and Style to Basic.

813. Click Ok to set up the query.

615. Set the Calculated Field Name to Label
Note: the name for this field can be anything, it will not change the way the union works if it's called something else.

716. Type Cost into the text box under the main calculation panel, as shown here, and click + Add to add it to the calculation.

817. Click the Validate button to ensure your calculation is built correctly.

918. Click the Save button to complete your calculation.

519. Click on the + to create a calculated field, in the bottom of the View Fields List panel.

620. Set the Calculated Field Name to Cost
Note: the name for this field can be anything, it will not change the way the union works if it's called something else.

721. Click on the ∑ button.

x22. Select the Camp Cost field from the Select Field drop down, and click + Add.

x23. Close the bracket by clicking ).

x24. Click the * button to multiply the field by a value.

x25. Type -1 into the text entry field, and click + Add to put in your calculation.

826. Click the Validate button to ensure your calculation is built correctly.

927. Click the Save button to complete your calculation.

1028. Drag the Camp Region field into the Sub Query Fields list, directly next to the Camp Region field in the Master Query Fields list.

1029. Drag the Label calculated field into the Sub Query Fields list, directly next to the Label field in the Master Query Fields list.

1030. Drag the Cost calculated field into the Sub Query Fields list, directly next to the Sum Invoiced Amount field in the Master Query Fields list.

31. Change the name of the Sub Query to Cost and click Save to complete the Union.

1632. If you need to make changes to your sub query setup at all, click the Edit Settings link.

2535. While still in the Column Formatting menu, select the Sum Invoiced Amount field from the list on the left.

2636. Set the name to Invoiced 2013 and close the menu.

3343. You now have an active Append Sub Query report.