Given below are formats used for quantity and rate fields. Kindly follow the outlined process for the same.

* Change in field alias of field as per requirement

* It is used in summary field

1. ## will calculate sum of all columns.
Ex:- 1+2+3+4=10
2. #0# will show non-decimal values.
Ex:- 1234
3. #00# / #2# will show double decimal values.
Ex:- 1234.00
4. #000# / #3# will show triple decimal values.
Ex:- 1234.000
& same can be used by changing 3 with 4,5,6,etc.
5. #L# will open direct link and show data in it.
6. #CR# will display Cr after values.
Ex:- 1234Cr