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 |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |