Knowledge has a beginning but no end

Quantity and Rates fields formats used in SQL field alias

Priyanka Pradeep Nalawade

2022-10-13 11:36:13

    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

    Related Articles