Adrian Simpkins Posted January 10, 2023 Share Posted January 10, 2023 Hi All I have a report generating from Supplier Manager where we pull in a number of fields. We have noted that for some reason the Total Contract Value is displaying in the report as below: Ideally I just want the value to display to 2 decimal points, but I am unsure how to set this against the field? Looks like this is a predefined field as the 2nd field we have set against h_custom_4 Many thanks Link to comment Share on other sites More sharing options...
AlexTumber Posted January 11, 2023 Share Posted January 11, 2023 @Adrian Simpkins thanks for your post. The h_value column in the database is of type DECIMAL. The h_custom_4 column in the database is of type VARCHAR. That would explain the discrepancy in precision. Alex 1 Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted January 11, 2023 Author Share Posted January 11, 2023 Thanks Alex, I suspected it may be down to the field format - thank you for confirming. Many thanks as always 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now