topic ROUNDUP in SQL in DAX Commands and Tips

ROUNDUP in SQL

Anonymous — Mon, 28 Oct 2019 16:12:04 GMT

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.

Re: ROUNDUP in SQL

Anonymous — Tue, 29 Oct 2019 05:47:00 GMT

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 🙂

Re: ROUNDUP in SQL

Anonymous — Thu, 31 Oct 2019 23:48:26 GMT

Thank you, Anonymous yes, I posted in SQL community also.

still no luck.