5 Replies Latest reply on Nov 24, 2016 4:59 AM by Shinichiro Murakami

    Calculated Field (Divide number of records)

    Eoghan Lyons

      Hi there,


      I have a spreadsheet with a list of passenger types, some labelled as Adult, some labelled as Child.

      I'm looking to find the ratio of Adults to Children.


      I have thought of creating a calculated field which divides the number of records of Adults / number of records of child but I can't figure out the syntax for the life of me.


      Can anyone advise me how best to proceed?


      Many thanks,