Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
4 years ago

Calculating Percentage Differences

Can someone please provide insight to this error? I  am trying to compare summary percentages. The first line works but the second and third lines are giving an error.

  • I have a group of tasks per project
  • I am summarizing the %Complete and %Expected back up to the parent table as an average for each group of tasks per project
  • This formula is being written as a report field for the report I am trying to create.


------------------------------
Joey Zint
------------------------------
Formulas and functions

9 Replies

Sort By
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    What is it that you're trying to do here:


    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • ZintJoseph's avatar
      ZintJoseph
      Qrew Captain
      4 years ago
      This is the formula. I am trying to measure %Complete again %Expected. The first line of code works but the other two do not

      If(
      [% Complete (Avg)] > [% Expected (Avg)],"<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"/>",
      [% Complete (Avg)]<=10 [% Expected (Avg)],"<img src=\"https://images.quickbase.com/si/16/223-point_yellow.png\"/>",
      [% Complete (Avg)] >10 [% Expected (Avg)],"<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"/>"

      ------------------------------
      Joey Zint
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        4 years ago
        Ok, but what are you trying to state with this:

        [% Complete (Avg)]<=10 [% Expected (Avg)]

        Is this intended to be [% Complete (Avg)] is less than or equal to 10 * [% Expected (Avg)]?

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quick Base Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------