8,849
edits
Changes
→Formatting
{{MySQL Syntax}}
The ''Calculated Field'' in the [[Report Builder]] allows you to specify MySQL statements to be executed when generating the report.
{{MYSQLDATETIMEFORMATS}}
===Calculate Business Day===
To calculate number of business day had passed, you need to do the following:
1. Create a holiday calendar and add all the holiday within that calendar.
2. Use the following syntax within Calculated Field when you build your report
'''Syntax'''
SS_FUNC.countbusdays(date1,date2)
'''Example'''
SS_FUNC.countbusdays(now(),[this])- 1
==Conditional Statements==
THEN 'Thank for your submission' WHEN 'Status 3' THEN 'Congratulations' ELSE 'I have no comment' END
==Formatting==
To add a line break between two values in the calculated field, use syntax such as the following:
<nowiki> concat([2],"<br>",[3])</nowiki>
This will make the column display the value in column 2 of the Report Builder, followed by a line break, followed by the value in column 3.
==See Also==
