D
dfeigen115
I'm using an Enterprise Project Number to calculate an display a field using
a formula. The formula is a CPI but uses the ACWP from our accounting system
(stored in enterprise cost1) vs the CPI that MSP uses. The resulting number
needs to display at least 2 decimal digits, preferably 3. However, the
number that is displayed is truncated to 1 digit eg .91 display as .9 and .98
displays as .9.
Is there any function that I can use to force the display to the desired
format?
Thanks in advance for your your assistance.
Dan
a formula. The formula is a CPI but uses the ACWP from our accounting system
(stored in enterprise cost1) vs the CPI that MSP uses. The resulting number
needs to display at least 2 decimal digits, preferably 3. However, the
number that is displayed is truncated to 1 digit eg .91 display as .9 and .98
displays as .9.
Is there any function that I can use to force the display to the desired
format?
Thanks in advance for your your assistance.
Dan