Can't seem to figure out a formula.

  • Profile Image
    Pistol865
    Asked on April 25, 2017 at 02:21 PM

    Here's my problem:

    I have three fields:

    1) What group will be attending this meeting?

    2) Area Breakouts

    3) Region Breakouts

    Within them, I have values assigned to specific groups.

    Below them is a field:

    How many people will be attending this meeting?

    In this field I need to populate it with the all the lesser values being added together and getting a final total.

    i.e.: in What group will be attending this meeting? DXS AE and DXS FAS is clicked. Each with a total number of attendees being 76 and 65 respectively.

    in Area Breakouts, the Area Business Meeting - Central and Area Business Meeting - West, is ticked, with values of 25 and 30 respectively.

    In the field How many people will be attending this meeting? I need it to recognize the lesser values of 25 and 30 ( and NOT the 76 and 65 which were also ticked) and add them up to get a total of 55.

    If the groups weren't broken up into "Area" or "Region", I need the field How many people will be attending this meeting? to be populated by the total of just the What group will be attending this meeting? field.

    I have a form calculation widget associated with the How many people will be attending this meeting? field. But I can't figure out what calculation formula I need to put in there.

    Any help is extremely appreciated.

     

    PM

     

     

  • Profile Image
    jonathan
    Answered on April 25, 2017 at 04:11 PM

    Allow me some more time to figure out the correct formula needed for your form requirement.

    I will get back to you as soon as I have update on this.

    Thank you.

  • Profile Image
    Pistol865
    Answered on April 25, 2017 at 04:55 PM

    Thank you!!