Wrapping Negative Amount Values in Reports

Sigma enables you to wrap the negative 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.



To enable the negative amount values in reports to be displayed within the wrapped brackets, 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: 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:

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

   The negative amount values can be wrapped within the brackets in PDF, DOCX, and HTML reports only

   
   
   

4. 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.
   
   
   
   
   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.
   
   
   
   The downloaded report displays the negative amount values within the wrapped brackets, as shown in the following screen shot: