Please enable JavaScript to view this site.
This program will calculate the percentage of parameter 1 using parameter 2 passing back the result in parameter 1. This can be useful if needing to calculate a Discount or VAT for example. The program can handle both positive and negative values and will also remove any non numeric characters such as currency symbol , thousand delimiter etc. from the input string. Note: No currency symbol or thousand delimiter will be returned.
You can choose to add [*ADD] or subtract [*SUB] using parameter 3 the percentage to / from respectively from the input value giving a resultant value passed back in parameter 2. If you do not pass a variable in this parameter *ADD is assumed.
Depending upon what is passed in parameter 4 the program will either round [*YES] or truncate [*NO] the results returned to the number of decimals specified. If you do not pass a variable in this parameter rounding = *YES is assumed.
The default is to return the results as a two decimal numeric field of length eleven e.g. nnnnnnnn.nn [8 numeric the decimal point and two decimal]. The number of characters returned before the decimal point is always eight but you may alter the number of decimals by passing the value of 0 – 5 in parameter 6. If you alter the number of decimals returned then the return value length will change accordingly from 8 – 15 respectively. An extra “-“ character will be returned at the end of the string if the value is negative.
Parameter |
In |
Len |
Out |
Len |
PARM1 |
Input Value |
132 |
Percentage value |
8 - 15 |
PARM2 |
Input Percentage |
132 |
Resultant value |
8 - 15 |
PARM3 |
*ADD or *SUB |
4 |
- |
|
PARM4 |
Round result *YES or *NO |
4 |
- |
|
PARM5 |
- |
|
- |
|
PARM6 |
Position 1 = Number of decimals (0 - 5) or Blank for default of 2 Position 2 = Decimal point if not "." e.g. ”,” (From version 7.0.0) |
1 |
- |
|
From version 7.0.0
Note: The second character of PARM6 can contain the decimal point character, if it is not a ". " e.g. a comma ",". The default will always be a ".". This character will be used for both the input and output values.