How calculate the percentage of the sum in two fields

[#1]

Hello everyone,

I am creating a text box, where i want to show the total percentage of Male and Female.

Below is a print screen of my data base:

Anyone could help me on this?

Regards

[sunny_talwar · Accepted solution]

May be something like this:

For Males:

=Sum(Male) / (RangeSum(Sum(Male), Sum(Female)))

For Females:

=Sum(Female) / (RangeSum(Sum(Male), Sum(Female)))

[#3]

Thanks Sunny

[sunny_talwar]

Not a problem

I am glad I was able to help