Overview
| Wiki Markup |
|---|
{html}<iframe width="700" height="394" src="https://www.youtube.com/embed/1O7ogaEZ4p0?color=white" frameborder="0" allowfullscreen></iframe>{html} |
Introduction
In this tutorial, we will walk through setting up a Union sub query. A good way to think about Unions is - use them if you need to combine multiple fields into the one column, either from the same or different views or sources.
...
| Section |
|---|
| Column |
|---|
| 6. 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. 7. Type Invoiced into the text box under the main calculation panel, as shown here, and click + Add to add it to the calculation. |
| Column |
|---|
| 
|
|
...
| Section |
|---|
| Column |
|---|
| 15. 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. 16. Type Cost into the text box under the main calculation panel, as shown here, and click + Add to add it to the calculation. 17. Click the Validate button to ensure your calculation is built correctly. 18. Click the Save button to complete your calculation. |
| Column |
|---|
| 
|
|
...
| Section |
|---|
| Column |
|---|
| 19. Click on the + to create a calculated field, in the bottom of the View Fields List panel. 20. 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. 21. Click on the ∑ button. 22. Select the Camp Cost field from the Select Field drop down, and click + Add. 23. Close the bracket by clicking ). 24. Click the * button to multiply the field by a value. 25. Type -1 into the text entry field, and click + Add to put in your calculation. 26. Click the Validate button to ensure your calculation is built correctly. 27. Click the Save button to complete your calculation. |
| Column |
|---|
| 
|
|
...