Create Calculated Field in Report-Definition Grid Layout
I need to create a calculated field as below in a Grid Layout for a Report-Definition, but can not seem to find the correct way or is it even possible.
if(.subPlan==null?.planID:.planID+"("+.subPlan+")");
We are trying to save space, by grouping locigcal components together.
***Updated by Moderator: Vidyaranjan| Included Categories***
Pegasystems
IN
For the example given above, the following SQL function can address it in report definitions - https://docs-previous.pega.com/how-create-custom-sql-functions-reporting.
HTML format (control) can also be specified for a column to show details different from the column value. Note that report definition provides the option to select columns but hide them from display. Please refer - https://community.pega.com/sites/default/files/help_v71/procomhelpmain.htm