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,

      Eoghan.