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.



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

1. 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:

   <?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>
   
   
   

   
   
   
   

2. Once you make the appropriate changes to the Sigma-amountformats.xml file, proceed to restart your app server.

3. Configure the report as per your needs and requirements in Sigma Studio.

   Only for the PDF, HTML and DOCX formats, the negative numbers can be wrapped within the brackets.

   
   
   

4. Access the Sigma Application and click the Preferences option to select the relevant amount or currency format, e.g. Indian Currency Format.
   
   
   
   
   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.
   
   
   
   
5. Access the configured report and click the Run option to generate the report.
   
   
   
   
6. Download the generated report in the selected PDF format.
   
   
   
   The fetched data of the downloaded PDF report displays the negative values for the numbers, within the wrapped brackets, as shown in the following screen shot: