0

simple calculation base don gender

This is probably somewhere in the manual or in the forum, but I have looked and not found anything satisfactory.  I have a database of teams, in these teams are people, whose gender is identified (male/female inputs).  If I want to have a simple calculation of number of females and/or males per team....  total beginner here apologies for the simple question..... :)

5 replies

null
    • Ninox developer
    • Fabio
    • 5 yrs ago
    • Reported - view

    Hi Nigel... We are here to help, don't worry!

    Have a look here and try this dB I've made: https://www.dropbox.com/s/zaofn2xjjjltgpo/totalGender.ninox?dl=0

    • Nigel_Savage
    • 5 yrs ago
    • Reported - view

    Thank you so much Fabio! I am not sure how to translate that to my architecture though (it's quite possible the architecture isn't ideal too...) please see this database which is a copy with fictitious records.....  https://www.dropbox.com/s/x8ntjaf2nf7pmch/GRE.ninox?dl=0

    Basically I want to be able to click on a team and have a formula field that extracts the student gender and calculates/counts the numbers of male/female/other.  Apologies if the formula you entered is the correct one - I am quite clueless :)

    Thanks again for your help :) much appreciated

    • Ninox developer
    • Fabio
    • 5 yrs ago
    • Reported - view

    Hi. Have a look here:

    https://www.dropbox.com/s/h2yhohhhtfp1yt2/GRE%20v.2.ninox?dl=0

    Fabio

    • Nigel_Savage
    • 5 yrs ago
    • Reported - view

    Dear Fabio,

     

    This works wonderfully well!  Thank you so much for your help - need to start learning coding skills!  

    Nigel

    • Ninox developer
    • Fabio
    • 5 yrs ago
    • Reported - view

    Hi Nigel.. you're welcome!! :)

Login to reply

Content aside

  • 5 yrs agoLast active
  • 5Replies
  • 1764Views