10 Replies Latest reply on Apr 25, 2017 12:14 PM by meersworld

    Decimal Number in Calculation (Text), Characters after Decimal Point

    meersworld

      I am including the dollar currency amount from a properly-formatted number field in a text calculation field.  I want to be sure the dollar amount in the calculation field shows two decimal places.  Now only both decimal places are show in the amount if there is an actual cents amount in both places of the current field.  No zeros show for an full dollar amount and only one digit shows when there is only an amount in the tens field.  I need both digits to show from the number field after the decimal point.  I think I could just add the appropriate number of zeros if I could calculate how many characters were to the right of the decimal point when the number was converted to text.  Thanks.