Cost Value on Reports

[Michael Sharp]

When we run a report on purchase price, we are presented with an additional 12 zeros on the end of each price.  Please can you advise if this a fault with the system or our configuration?

Regards,

Mike.

[Guest Chaz]

I've asked internally to see if there's a better way for us to handle these cost fields, but to get you going, you can use the ROUND or TRUNCATE functions to convert the data to 2 decimal places:

SELECT
	ROUND(h_cost, 2) AS cost
FROM
	h_cmdb_assets

SELECT
	TRUNCATE(h_cost, 2) AS cost
FROM
	h_cmdb_assets

Round will round the number depending on if there's a value in the third decimal place. Truncate will literally cut it off after 2 decimal places.

Hope that helps.

[ArmandoDM]

Hi @Michael Sharp,

could you specify which precision would be appropriate, please?

Would a precision of 2 decimals be appropriate?

Regards,

Armando

[Michael Sharp]

49 minutes ago, ArmandoDM said:

Hi @Michael Sharp,

could you specify which precision would be appropriate, please?

Would a precision of 2 decimals be appropriate?

Regards,

Armando

Hi Armando, obviously........?

[ArmandoDM]

Hi Michael,

the precision of the decimal properties has been set to 2. The change will be available in the next relase.

Regards

Armando