Copy the string data into currency field

[Jyoti Tripathi]

Hi All, I have a requirement to copy the pay rate(string field) from caller field to wage field(currency field) and it should be truncated to two decimal places.

Example- if user's pay rate is 56.8867 then wage field should populate as $56.88

please kindly help

[Anil Lande · Accepted solution]

Hi,

Try below:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
    if (isLoading) {
        return;
    }
    if (newValue === '') {
        g_form.setValue('dollar_amount', 'USD;0.00');
        return;
    }
    var grievant = g_form.getReference('employee_id', callBack);

    function callback(grievant) {
        var payRate = parseFloat(grievant.u_pay_rate_amount);
		g_form.setValue('dollar_amount', 'USD;'+currValue);
        var currArr = payRate.split('.');
        var decPart = currArr[1];
        if (decPart.length > 2) {
            var x = Number(grievant.u_pay_rate_amount);
            var currValue = "USD;" + Math.round(x * 100) / 100;
            g_form.setValue('dollar_amount', currValue);

        }
    }
}

[Anil Lande]

Hi @Jyoti Tripathi ,

Did you get chance to try this?

[Jyoti Tripathi]

@Anil Lande : Yes, but it is giving me incorrect value  for example  for 145.677, it is giving 0.67 

[Anil Lande]

It is working fine for me, please share your latest script.

[Shamma Negi]

Ideally as per mathematical expression, if the value 123.677 it should round up to 123.68 which is correct calculations 

parseFloat(strValue).toFixed(2);