PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

Crystal Report Formula Default Value for NULL

Crystal Report formula generally used to Count, Summarize, or any other Arithmetic function in Crystal Report. Depends on query result, the value for one of the field either NULL or NOT NULL. The problems are: Formula in Crystal Report wouldn’t count or do any arithmetic function, if the component of the formula  is NULL, then the result will be shown as Empty. (Sometimes causing error while executing crystal report). Example 1: String1 + NULL , will show empty result, the expected result is String1 Example 2: 1000 + NULL, will show empty result, the expected result is 1000,  we can

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Register now for unlimited access to

Existing Users Log In
Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055

, , ,