Leading 0 and +

[LauraW]

Hi,

I have a field that is a text field that needs to be formatted as a decimal. It's a pay rate field that can either be formatted like $12.50 or $32,000 depending on if the rate is hourly or salary.

When bringing the field (string) in straight from my database the field shows as follows:

000000080000000000+

I can remove the leading zero's but I can't seem to be able to format the last half of the field. This is point who I've gotten

totext(val({PERSACTION.NEW_VALUE_24}),0,"") Which will come out to 80000000000 but the value should show as 80,0000.00

If I change it to a number, it comes out like:

tonumber(val({PERSACTION.NEW_VALUE_24}))//,0,"") it comes out like 80,000,000,000.00. I'm sure the employee wouldn't mind making that much money but I still need it to show as 80,000.00

Can anyone help with this?

 

[Charliy]

tonumber(val({PERSACTION.NEW_VALUE_24}))//,0,"")/100

Then use formatting to show the decimals.

 

[LauraW]

That worked. Thank you!