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
------------------------------

9 Replies

• 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/
------------------------------
• 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
------------------------------
• 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/
------------------------------