Apsona Multi-Step Reports allow you to create calculated string fields that dynamically display text based on the values of multiple checkbox fields. This is useful when you want to present a single, user-friendly field instead of displaying separate Yes/No checkbox columns.
For example, if an Opportunity contains two checkbox fields—Canvasback and Merganser—you can create a calculated field named Rooms Booked that returns:
Canvasback when only the Canvasback checkbox is selected.
Merganser when only the Merganser checkbox is selected.
Canvasback, Merganser when both checkboxes are selected.
A blank value when neither checkbox is selected.
First, ensure that both checkbox fields are included in the appropriate retrieval step of the Multi-Step Report. Then, create a Calculated String field using the following formula:
({!StepName.Canvasback} ? "Canvasback" : "") +
({!StepName.Canvasback} && {!StepName.Merganser} ? ", " : "") +
({!StepName.Merganser} ? "Merganser" : "")
Replace StepName with the actual name of the report step that contains the checkbox fields.
The formula uses conditional (?:) operators and string concatenation (+) to generate the appropriate output based on the selected checkboxes, automatically adding a comma only when both values are present.
To avoid formula errors, use the Insert Field Reference option when selecting fields, ensure the correct report step is referenced, and verify that the required checkbox fields are included in the retrieval step before creating the calculated field.
This approach provides a simple and maintainable way to combine multiple checkbox values into a single descriptive field without requiring additional Salesforce formula fields.