C# Check if a decimal has more than 3 decimal places?

Question

I have a situation that I cannot change: one database table (table A) accepts 6 decimal places, while a related column in a different table (table B) only has 3 decimal places.

I need to copy from A to B, but if A has more than 3 decimal places the extra data will be lost. I cant change the table definition but I can add a workaround. So I'm trying to find out how to check if a decimal has more than 3 decimal places or not?

eg

Table A
Id, Qty,  Unit(=6dp)
1,  1,     0.00025
2,  4000,  0.00025

Table B
Id, TotalQty(=3dp)

I want to be able to find out if Qty * Unit from Table A has more than 3 decimals (row 1 would fail, row 2 would pass):

if (CountDecimalPlaces(tableA.Qty * tableA.Unit) > 3)
{
    return false;
}
tableB.TotalQty = tableA.Qty * tableA.Unit;

How would I implement the CountDecimalPlaces(decimal value) {} function?

score 74 · Answer 1 · answered May 29 '12 at 08:05

74

You could compare the value of the number rounded to 3 decimal places with the original value.

if (Decimal.Round(valueDecimal, 3) != valueDecimal)
{
   //Too many decimals
}

answered May 29 '12 at 08:05

RodH257

3,552
5
36
46

Easy to read and easy to change the # of decimals places. A nice elegant piece of code, thanks! – crabCRUSHERclamCOLLECTOR Jun 20 '12 at 14:56
Just the answer I was going to add after I read the accepted solution, but you already have! – SharpC Nov 20 '15 at 13:13

carlosfigueira · Accepted Answer · 2020-05-22T20:04:49.210

This works for 3 decimal places, and it can be adapted for a generic solution:

static bool LessThan3DecimalPlaces(decimal dec)
{
    decimal value = dec * 1000;
    return value == Math.Floor(value);
}
static void Test()
{
    Console.WriteLine(LessThan3DecimalPlaces(1m * 0.00025m));
    Console.WriteLine(LessThan3DecimalPlaces(4000m * 0.00025m));
}

For a real generic solution, you'll need to "deconstruct" the decimal value in its parts - take a look at Decimal.GetBits for more information.

Update: this is a simple implementation of a generic solution which works for all decimals whose integer part is less than long.MaxValue (you'd need something like a "big integer" for a trully generic function).

static decimal CountDecimalPlaces(decimal dec)
{
    Console.Write("{0}: ", dec);
    int[] bits = Decimal.GetBits(dec);
    ulong lowInt = (uint)bits[0];
    ulong midInt = (uint)bits[1];
    int exponent = (bits[3] & 0x00FF0000) >> 16;
    int result = exponent;
    ulong lowDecimal = lowInt | (midInt << 32);
    while (result > 0 && (lowDecimal % 10) == 0)
    {
        result--;
        lowDecimal /= 10;
    }

    return result;
}

static void Foo()
{
    Console.WriteLine(CountDecimalPlaces(1.6m));
    Console.WriteLine(CountDecimalPlaces(1.600m));
    Console.WriteLine(CountDecimalPlaces(decimal.MaxValue));
    Console.WriteLine(CountDecimalPlaces(1m * 0.00025m));
    Console.WriteLine(CountDecimalPlaces(4000m * 0.00025m));
}

+1 - I think LessThan3DecimalPlaces should be LessThanOrEqualTo3DecimalPlaces :) — VoodooChild, Mar 08 '12 at 06:03
CountDecimalPlaces will make an infinity loop if called with dec == 0 — Henrik Stenbæk, Aug 07 '12 at 10:46
@LuisLavieri / HenrikStenbæk good catch; I've updated the function to account for those cases. — carlosfigueira, May 22 '20 at 20:03

score 11 · Answer 3 · answered Mar 01 '13 at 06:00

11

This is a very simple one line code to get count of decimals in a Decimal:

decimal myDecimal = 1.000000021300010000001m;
byte decimals = (byte)((Decimal.GetBits(myDecimal)[3] >> 16) & 0x7F);

answered Mar 01 '13 at 06:00

Jaska

1,412
1
18
39

This should be the answer, you just were late to the party. Nicely done. Out of curiosity, why (byte) and not (int) or something? – JesusIsMyDriver.dll Jul 19 '18 at 20:56

score 5 · Answer 4 · answered Oct 12 '12 at 20:42

Multiplying a number with 3 decimal places by 10 to the power of 3 will give you a number with no decimal places. It's a whole number when the modulus % 1 == 0. So I came up with this...

bool hasMoreThanNDecimals(decimal d, int n)
{
    return !(d * (decimal)Math.Pow(10, n) % 1 == 0);
}

Returns true when n is less than (not equal) to the number of decimal places.

score 3 · Answer 5 · answered May 23 '11 at 02:29

The basics is to know how to test if there are decimal places, this is done by comparing the value to its rounding

double number;
bool hasDecimals = number == (int) number;

Then, to count 3 decimal places, you just need to do the same for your number multiplied by 1000:

bool hasMoreThan3decimals = number*1000 != (int) (number * 1000)

score 3 · Answer 6 · edited Apr 05 '12 at 19:22

All of the solutions proposed so far are not extensible ... fine if you are never going to check a value other than 3, but I prefer this because if the requirement changes the code to handle it is already written. Also this solution wont overflow.

int GetDecimalCount(decimal val)
{
    if(val == val*10)
    {
        return int.MaxValue; // no decimal.Epsilon I don't use this type enough to know why... this will work
    }

    int decimalCount = 0;
    while(val != Math.Floor(val))
    {
        val = (val - Math.Floor(val)) * 10;
        decimalCount++;
    }
    return decimalCount;
}

score 2 · Answer 7 · answered Aug 07 '12 at 10:47

carlosfigueira solution will need to check for 0 otherwise "while ((lowDecimal % 10) == 0)" will produce an infinity loop when called with dec = 0

static decimal CountDecimalPlaces(decimal dec)
    {
        if (dec == 0)
            return 0;
        int[] bits = Decimal.GetBits(dec);
        int exponent = bits[3] >> 16;
        int result = exponent;
        long lowDecimal = bits[0] | (bits[1] >> 8);
        while ((lowDecimal % 10) == 0)
        {
            result--;
            lowDecimal /= 10;
        }
        return result;
    }

    Assert.AreEqual(0, DecimalHelper.CountDecimalPlaces(0m));      
    Assert.AreEqual(1, DecimalHelper.CountDecimalPlaces(0.5m));
    Assert.AreEqual(2, DecimalHelper.CountDecimalPlaces(10.51m));
    Assert.AreEqual(13, DecimalHelper.CountDecimalPlaces(10.5123456978563m));

score 2 · Answer 8 · answered Dec 17 '15 at 12:32

2

One more option based on @RodH257's solution, but reworked as an extension method:

public static bool HasThisManyDecimalPlacesOrLess(this decimal value, int noDecimalPlaces)
{
    return (Decimal.Round(value, noDecimalPlaces) == value);
}

You can then call that as:

If !(tableA.Qty * tableA.Unit).HasThisManyDecimalPlacesOrLess(3)) return;

answered Dec 17 '15 at 12:32

tomRedox

28,092
24
117
154

I was going to answer the same, an extension method is certainly the most re-useful solution. I named the method HasMaxDecimalPlaces() just to simplify "this many or less" to "max" – Richard Jun 07 '20 at 10:39

score 1 · Answer 9 · edited May 23 '11 at 02:34

1

    bool CountDecimalPlaces(decimal input)
    {
        return input*1000.0 == (int) (input*1000);
    }

edited May 23 '11 at 02:34

pickypg

22,034
5
72
84

answered May 23 '11 at 02:26

Bala R

107,317
23
199
210

score 1 · Answer 10 · answered May 23 '11 at 02:28

1

There is probably a more elegant way to do this, but off the top of my head I would try

a = multiply by 1000
b = truncate a
if (b != a) then there is additional precision that has been lost

answered May 23 '11 at 02:28

Jason

86,222
15
131
146

score 1 · Answer 11 · answered May 22 '20 at 14:48

Here is my version:

public static int CountDecimalPlaces(decimal dec)
{
    var a = Math.Abs(dec);
    var x = a;
    var count = 1;
    while (x % 1 != 0)
    {
        x = a * new decimal(Math.Pow(10, count++));
    }

    var result = count - 1;

    return result;
}

I tried first @carlosfigueira/@Henrik Stenbæk, but their version does not work with 324000.00m

TEST:

Console.WriteLine(CountDecimalPlaces(0m)); //0
Console.WriteLine(CountDecimalPlaces(0.5m)); //1
Console.WriteLine(CountDecimalPlaces(10.51m)); //2
Console.WriteLine(CountDecimalPlaces(10.5123456978563m)); //13
Console.WriteLine(CountDecimalPlaces(324000.0001m)); //4
Console.WriteLine(CountDecimalPlaces(324000.0000m)); //0

score 0 · Answer 12 · edited Sep 14 '12 at 17:33

0

Public Function getDecimalCount(decWork As Decimal) As Integer

    Dim intDecimalCount As Int32 = 0
    Dim strDecAbs As String = decWork.ToString.Trim("0")

    intDecimalCount = strDecAbs.Substring(strDecAbs.IndexOf(".")).Length -1

    Return intDecimalCount

End Function

edited Sep 14 '12 at 17:33

Steve Czetty

6,147
9
39
48

answered Sep 14 '12 at 15:56

Ricardo

105
1
11

Could you add some explanation of the solution to the code you have there? – jonsca Sep 24 '12 at 12:35
I didnt care about extra zeros, so, the decWork.ToString.Trim("0") removes them and .50 becomes .5 strDecAbs.SubstringstrDecAbs.Substring(strDecAbs.IndexOf(".")).Length -1 gives the length of the string from the decimal point and since the point is included I subtract 1. – Ricardo Sep 24 '12 at 15:38
1

Won't work for all languages unless culture info is specified so be careful – Mikael Holmberg Sep 12 '19 at 14:28

score 0 · Answer 13 · answered May 23 '11 at 02:28

0

could you convert it to a string and just do a len function or would that not cover your situation?

follow up question: would 300.4 be ok?

answered May 23 '11 at 02:28

Mark Hosang

501
5
21

C# Check if a decimal has more than 3 decimal places?

13 Answers13

Linked

Related