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,...
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 🙂
Thank you, Anonymous yes, I posted in SQL community also.
still no luck.