Sum of decimal values in Agentry does not give readable output.

[sudhiranjan_lenka]

Hello Experts,

In Work Manger-6.2, we have a requirement to find sum of multiple decimal values and to show it in the screen heading. we tried with different ways but could not achieve it.

we got the correct result(highlighted) but the result is not in readable format.Our scenario and the code are as mentioned below.

CATSRecords(Time Sheet) object contains one decimal property with the name ZCATSHours, which store the duration(in hours) for a time sheet entry.

In Work Manager time sheet tab, we want to display the total durations for a selected date as time sheet list header.

Your expert advices would be appreciated a lot.

Thanks,

Sudhir.

[former_member404321 · Accepted solution]

Hi Sudhir,

I think Format Decimal function would do. Before converting the output to the String format, you should use Format Decimal function adding the precision parameter.

Thanks and Regards,

Sujit

[bill_froelich]

Sudhir,

I would suggest starting with adding a precision to your FROM_DECIMAL_NUMBER function call.  The display appears to be related to a rounding precision issue with your sum. 

--Bill