Wrapping Negative Numbers in Reports

Sigma enables you to wrap the negative numbers, displayed as data sets in your functional reports. A sample screenshot of the report is provided as follows, in which the negative numbers are displayed within the wrapped brackets. Anchor_GoBack_GoBack Image Removed
To enable the negative numbers amount values within brackets in reports. In the following sample report you can notice that the negative values in the TOTAL column are wrapped within brackets.

Image Added

To enable the negative amount values in reports to be displayed within the wrapped brackets for the data sets of your functional reports, perform the following steps:

In the Sigma-amountformats.xml file on the SigmaResources.jar, present in your Sigma Application WAR folder (e.g. D:\Canvas\apache-tomcat-10.0.18\webapps\sigma\WEB-INF\lib\SigmaResources.jar), specify the negative sign position as "WRAP" for the relevant currency format of your choice, e.g. Indian Currency Format, as shown in the following sample code snippet and the screen shot:

Image Removed

Once you make

In the Sigma-amountformats.xml file on the SigmaResources.jar, present in your Sigma Application WAR (sigma.war\WEB-INF\lib\SigmaResources.jar), specify the negative sign position as “WRAP” for the required currency format. The following code segment of Sigma-amountformats.xml shows the negative sign position attribute as WRAP for the Indian Currency Format:

Code Block

language	xml

<?xml version="1.0" encoding="UTF-8"?>
<canvas-formats type="amount">
	<format Id = "SouthAfrica" description = "SouthAfrica Currency Format" negativeSignPosition = "PREFIX"
		groupSeparator = " " decimalSeparator = "," groupSize = "3" leadingGroupSize ="3" 
		formatter-class = "com.intellectdesign.modelhouse.pref.CustomerAmountFormatter" 
		canOverride = "true" isEnabled = "true"/>
	<format Id = "USA" description = "US Currency Format" isEnabled = "false"/>
	<format Id = "INDIA" description = "Indian Currency Format" isEnabled = "false"/>
	<format Id = "###,###,###,###,###.###" description = "US Currency Format"
		groupSeparator = "," decimalSeparator = "." groupSize = "3" negativeSignPosition = "PREFIX"
		leadingGroupSize = "3" isEnabled = "true"/>
	<format Id = "#,###.##" description = "Indian Currency Format"
		groupSeparator = "," decimalSeparator = "." groupSize = "3" negativeSignPosition = "WRAP"
		leadingGroupSize = "2" isEnabled = "true"/>
</canvas-formats>

Image Added

Once you save the appropriate changes to the Sigma-amountformats.xml file, proceed to restart your app server.
Configure the report as per your needs and requirements in Sigma Studio.
Note: Only for PDF, HTML and DOCX formats, the negative numbers
Note
The negative amount values can be wrapped within the brackets
.

...

in PDF, DOCX, and HTML reports only
Image Added
Access the Sigma Application and click the Preferences option (top-right corner) to select the relevant amount or currency format, e.g. Indian Currency Format.

...

Image Added
1. Click the Amount drop-down list to select the relevant amount or currency format, e.g. Indian Currency Format.
2. Proceed to click Update to update the Preferences in Sigma Application.