Column Expression refuses to divide properly!

[MattWarner]

I have a virtual column (formatted as a percent), and I want it to display the percentage after dividing:

customers paid / total customers of type “regular”

customers paid is in a Payments table, which contains the virtual column. This table REFS a Client List table that determines client type. However the result is never correct. I have:

1. checked the decimal digits, max/min, and step value in the column editor
2. reformatted the column as a decimal type, and checked digits/step value
3. Verified that both the numerator and denominator expressions give the right value by themselves
4. checked spacing

The result is “0.00”. The final nail is that simply putting in the correct static values - which with my sample data is 4/13 - also gives “0.00” or 0.00%. There’s got to be something dumb that I am not seeing!

Here’s the formula exactly as written:

(COUNT(
       SELECT(
              Payments[Month Paid?],[Month Paid?]=true
             )
       )
) / (Count(
         SELECT(
                Client List[Client Type],[Client Type]=Regular
               )
        )
)

Any help is greatly appreciated!

[Marc_Dillon · Accepted solution]

Fix for expression giving 0% or missing decimal part Tips & Tricks 💡

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…

[MattWarner]

Thank you!

I forgot that COUNT returns a number type not a decimal type…

I swear I searched for previous answers before posting… Thanks again.

[Marc_Dillon]

MattWarner:

I swear I searched for previous answers before posting

yah,right…