| Example 1: Customising Sub-total cells combining text and the Master Detail
You have a report that contains sections and sub-totals. You want cells to contain some text, and the values for the object that the section was created on to describe what the sub-total is for. Answer
This is done by combining text and an object in a cell (concatenation). Solution
We write a formula (using the Formula Editor button) to combine the text and the Master Detail, which is done in the cell that contains the text “Sum:”.
- Click on the cell (in this example, the cell that contains the text “Sum:”).
- Click on the Formula Editor button in the toolbar, which will open the Formula Editor window
- Insert the formula “Text”&[object]
- See the example below, where Permanent Country is the object used to create a section
Text and object are now combined to customise the sub-total cells
Example 2: Customising cells combining text and count totals
You have a report that contains Ids, and sections. You want cells to contain some text, and the sub-total values, eg “5 Students”. A measure has not been used. Answer
This is done by combining text and an object in a cell (concatenation). Solution
We write a formula (using the Formula Editor button) to combine the text and the number detail.
- Insert a Count on the ID field
- Click on the cell (in this example, the cell that contains count data)
- Click on the Formula Editor button in the toolbar, which will open the Formula Editor window
- Insert the formula FormatNumber(Count(<ID>) ,"#")&”Text”
- See the example below
- This is how the text and count total will look in the cell
 |