This article is part of the Replicon Gen2 knowledge base. If you’re looking for information on Replicon Gen3, which is the latest version of Replicon, please visit:

Scenario:
Web TimeSheet administrator would like to report on users' data in the disabled department. However, the administrator wouldn't want to (Disabled) remark next to the department names as it doesn't look good when presenting the users' data to the management.

Resolution:
Use the following formula as a reference and create a new formula with department names suitable to your organization,
If(DepartmentName="HR (Disabled)","HR",
If(DepartmentName="Admin (Disabled)","Admin",
If(DepartmentName="Management (Disabled)","Management",
If(DepartmentName="Customer Support (Disabled)","Customer Support",NumberToText(0)

)
)
)
)

 

Note:
Refer the attached screenshots for illustrations.