Copy link to clipboard
Copied
Hi there, thanks for reading.
Basically I have 4 boxes and 1 total box.
The total box sums up the 4 boxes as a number,
All i want to do is add a % symbol after the numbers.
The % format literally does a % calculation which I do not want.
For example in the 5 boxes i currently have:
10, 10, 10, 10, 40
I want
10%, 10%, 10%, 10%, 40%
Many thanks!!
Simon
Copy link to clipboard
Copied
I would set the format of the field to "Percentage" and then just add the custom calculation script without any decimal place adjustment. This approach uses the fact that the Format of a field only affects the field display and not the value of the field. This allows the value of the field to be used unchanged in other calculations.
Any value entered into a field is entered as the decimal value and not the percentage value. If one wants to add the "%" symbol and the changed decimal place, then one needs add additional calculations to filter the special symbol and adjust the decimal place any where that field's value is attempted to be used in another calculation.
Copy link to clipboard
Copied
I would set the format of the field to "Percentage" and then just add the custom calculation script without any decimal place adjustment. This approach uses the fact that the Format of a field only affects the field display and not the value of the field. This allows the value of the field to be used unchanged in other calculations.
Any value entered into a field is entered as the decimal value and not the percentage value. If one wants to add the "%" symbol and the changed decimal place, then one needs add additional calculations to filter the special symbol and adjust the decimal place any where that field's value is attempted to be used in another calculation.
Copy link to clipboard
Copied
That sounds fine. Much appreciated!
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more