Decimal Precision on a Reports

[Jeya priya]

Decimal Precision on a Reports  - Sum of cost field, it showing the count in currency, attached imaged i wan t to truncate the decimals can anyone suggest me what to do , I know for decimal precision is not supported for currency field

[Ankur Bawiskar · Accepted solution]

@Jeya priya 

yes "Value formatting" is not supported on currency field

Did you try to explore function field and use substring or some manipulation to round off?

Function Fields in ServiceNow Reports: Calculate and Display Data on the Fly 

Report on function fields 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@Jeya priya 

yes "Value formatting" is not supported on currency field

Did you try to explore function field and use substring or some manipulation to round off?

Function Fields in ServiceNow Reports: Calculate and Display Data on the Fly 

Report on function fields 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG · Accepted solution]

Hi @Jeya priya 

There is no other way , as it is nor supported OOTB.