Page 1 of 1

Percentages?

Posted: Mon Feb 06, 2023 4:16 pm
by ste
Hello, maybe it's not brand new, but I don't know how to calculate a percentage.

I have these absolute events observed
a - 28
b - 8
c - 3
d - 4
e - 3
f - 6
g - 5
h - 3
i - 7

And I want to know the percentage on the total (67), How do I proceed? I tried Frequencies Tables, but it's not what I am looking for.
👇🏼
a - 28 (28/67*100=41.8%) and so on
b - 8
c - 3
d - 4
e - 3
f - 6
g - 5
h - 3
i - 7

Re: Percentages?

Posted: Tue Feb 07, 2023 12:09 am
by Bobafett
I did it via the transform function: $source/VSUM(A)*100

$source = column A (which contains all your values on separate rows)
VSUM(A)= sum of variable A

Re: Percentages?

Posted: Tue Feb 07, 2023 9:55 am
by ste
Thanks it's working! 🙏

Do u know how can I round to the first decimal? 41.8% and so on?

I used ROUND ('Column of variable I need', digits=1) but I got an error: DIGITS is not an argument for ROUND ()

If I use only ROUND ('Column of variable I need') it works

Re: Percentages?

Posted: Tue Feb 07, 2023 11:32 am
by Bobafett
I just tried this and it seems to work:

ROUND(($source/VSUM(A)*100), 1)

Re: Percentages?

Posted: Tue Feb 07, 2023 11:53 am
by ste
Yeah great! thanks! 💪