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:
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!
Solved! Go to Solution.
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.
yah,right…
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |