How to round field in SAP Crystal Report 2011?
Rounding of static value is different from rounding DB field value in SAP B1 crystal report 2011
I have 609,437.50 from Database when I go to Field Format and then round field I get 609,437
I have 609,437.50 in formula as static value when I round I get 609,438 which is correct same as excel
How can I round Database field and get value like 609,438 while I have 609,437.50?
Please anyone can help me
You likely have database value different from xxx.50.
What data type is your value in database - some float or decimal or money?
If float, then you have to convert it to decimal first - float values are inexact and rounding may behave strangely.
If decimal or money, then you may have more decimal places filled (like xxx.499), which rounds down again. You need either accept your results or round to two decimals first; this can be visually better, but is wrong mathematically.
- Crystal reports if/and/else
- Stored Procedure not showing fields in Crystal reports
- Crystal Report - shared numbervar
- Crystal Report: How to use the Operator 'in' with if conditions
- Crystal Report SP26 SetDataSource() Method failed in computers of clients in Visual Studio 2019
- Get sum of a field per page in crystal report
- When viewing a report inside an application, the parameter prompt redisplays when moving to the next page
- removing decimals in crystal reports for number field
- ASP.net: Crystal Reports - Subreport over multiple pages
- Crystal reports sort group-by in natural order
- How to find an SQL error in Crystal Reports?
- "Error applying transforms. Verify that the specified transform path are valid." when uninstalling
- Report formula for Over90Days
- SAP Crystal Reports & VS 2015
- This method(chr()) does not support unicode in crystal report.. so how to use unicode in crystal?
- How to open HANA DB report in Java?
- Why do I get a "Failed to export the report" error when I try to export a Crystal Report to an HTML file?
- Can I use Crystal Reports in Visual Studio 2022?
- Crystal Report throws 'Connection reset.' on document open
- Remove login requirements for Crystal Report
- Find instance of a formula on a report when it's been hidden
- Formula to change how a number is displayed in crystal reports
- Crystal report 2008: How to extract "Report Custom Function" content from the rpt file
- Intermittent Crystal Reports error "The request could not be submitted for background processing."
- Crystal Reports: "Failed to Save Document" after changing Datasource
- Crystal Report- how to round decimal in crystal report?
- How to group by one field and sort by another field with Crystal Report
- Crystal Report Running Total
- In Crystal Reports I have a Parameter field + 2 years
- In Crystal Reports, How do I count all the rows in the Details section and place that count in the header?