SAP Knowledge Base Article - Public

2646789 - Floor function in Crystal Reports


  • The "Floor" function for negative values works differently than in MS Excel
  • In Crystal Reports Floor(-0.2204) returns 0 , but in MS Excel Floor(-0.2204,1,1) returns -1


  • SAP Crystal Reports 2016


  • This is By Design behavior. According to Crystal Reports Help:  Values are always rounded down when they are adjusted away from zero (without regard to the sign of the value). If number is an exact multiple of multiple, no rounding occurs.


  • If required it is possible to workaround the behavior by manually creating a new formula. It all depends on expected results.


Round, Top, Bottom , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


SAP BusinessObjects Dashboards 4.2