Skip to main content
Question

Calculating the ""most"" used text answer or average of all text-multiple choice answers

  • November 27, 2018
  • 0 replies
  • 298 views
I have child "Task" records that each have a status assigned to the record. I want to calculate the overall status of the Parent "Deliverable" to give an idea of where all the sub tasks level in an overall status. 

For example out of 5 tasks 2 are yellow, 1 is red and 3 are green, so the overall status of the deliverable to describe the tasks would equal GREEN. 
    This topic has been closed for replies.

    np
    You would make a summary field on the Parent to total up the # of Greens, # of Yellows and # of red, in three separate fields.

    Then make a formula to calculate the average Task Status.

    Post back if you need help with the formula.
    • AylinNazlim
    • Author
    • Quickbase Alumni
    • November 30, 2018
    Hi QuickBase Coach,

    Could you please provide me with the formula as well? I will work on the summary fields first. 

    Thanks,
    Aylin
    • AylinNazlim
    • Author
    • Quickbase Alumni
    • November 30, 2018
    I actually think I did the Summary field incorrectly because of what I choose for the "Total of" part of the summary field. I think it's wrong because the total of the records on the screen shot says 6 and not 3. Please advise. 

    The summary field should just be a Count if the number of records. Nothing to do with the Record ID.
    Let me know when you have the summary fields working.
    Actually, here isa format for a formula

    var number Max = Max([# green], [# yellow], [#red])

    Case($Max,
    [#green], "Green",
    [#yellow], "Yellow",
    [#red], "Red")
    It needs a semi colin on his first line

    var Number Max = Max([Total Green Workstream Status], [Total Yellow Workstream Status], [Total Red Workstream Status]);
    • AylinNazlim
    • Author
    • Quickbase Alumni
    • December 8, 2018

    OK, now I see your relationship but you will need to explain this with an example

    I will also like to average the formula of the Average Task Statuses to the related parent record, would I make a formula-text field on the parent table for the Averaged child records of the Grand child records?
    Terms & ConditionsAccessibility statement