How to remove the Tran Type( -IN) from an invoice Number

In Report Manager:

1. Navigate to View>Windows>Fields

2. Right Click and select Add Calculated Field

3. Right Click on the new Calculated Field and click Edit Calculated Fields

4. Rename the field

5. Edit the expression

6. In the expression ad the following formula: Reverse(Remove(Reverse([TranID]),0 ,3 ))

7. Click Save

8. Replace existing TranID field in the report with the new one

   Breakdown of how the formula works:

   You start with Invoice Number 1234-IN
   Reverse([TranID] flips the invoice number to be NI-4321
   Remove(Reverse([TranID]),0 ,3 ) takes the NI-4321 and Removes the first three characters (3) starting at right before the first character (0). This give you a final product of 4321
   Reverse(Remove(Reverse([TranID]),0 ,3 )) This reverses the final product back to be 1234