Forum Discussion
ROUNDUP in SQL
Hi, I've used ROUNDUP in my report as per the requirement.
TotalPoints = IF(sum(Points)> 0.1
, FORMAT(ROUND(SUM(Points),1),"0.0")
, FORMAT(ROUNDUP(sum(Points),2),"0.00")) -- If less than 0.1, ex: 0.001, I want 0.01
am getting desired output in the report as user requested. Now am in the process writing test cases using SQL for validation and not able to re-produce the same output using SQL. what is the equivalent of ROUNDUP in SQL?
- CEILING is always rounding to nearest WholeNumber -- giving me 1.
- CAST(Points as decimal(16,2)) --- is giving me 0
- CAST(Points as decimal(16,3)) --- is giving me 0.002 - 3 Decimals (i want only 2 decimals).
Please help me.
2 Replies
Hi,
I think you will need to have this question posted in a SQL msdn Forum. But, Have you tried using ROUND() Function? The below is the link.
https://docs.microsoft.com/en-us/sql/t-sql/functions/round-transact-sql?view=sql-server-ver15
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂