Forum Discussion

AylinNazlim's avatar
AylinNazlim
Qrew Cadet
7 years ago

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

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 ov...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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's avatar
    AylinNazlim
    Qrew Cadet
    7 years ago
    Yay that worked! Also, how would I change the formula to keep the field blank if there are no related Workstream Status Records?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Make this change to blank the result if all zero.

    IF($Max > 0,

    Case($Max,

    [Total Green Workstream Status], "Green",

    [Total Yellow Workstream Status], "Yellow",

    [Total Red Workstream Status], "Red")

    If([PicExistsFull], "<a target='_blank' href=" & $URL & ">" & $Words & "</a>", " ")
    )


    be sure that the field properties of the the three Totals fields are set to treat blank as zero.