Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 19, 2019 05:45 AM
I have a rollup column in an aggregate table where I want to get a percentage. In the original record, I am recording 1, 0, or empty.
The basic components work … SUM(values) returns “6” … COUNTA(values) returns “8”
But … SUM(values)/COUNTA(values) returns “1”
Is this combined function not supported? or am I missing something ?
Mar 19, 2019 04:47 PM
Check the formatting of your field that’s doing the math between the SUM and the COUNTA. It might default to an integer because the source values are both integers, which would explain why it’s rounding 6/8 up to 1. Set it to a decimal and fiddle with the precision to your liking, and it should give you the percentage you seek.
Mar 21, 2019 05:03 AM
Operator error … I didn’t look at the formatting option and it was being forced to an integer of “1” … all better now.
Thanks!