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 p...
Forum Discussion
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/
------------------------------
------------------------------
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
------------------------------
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/
------------------------------No...... if % Complete is less than or equal to 10 compared to % Expected, show a yellow circle.
------------------------------
Joey Zint
------------------------------- Ok, in Quick Base, you can't string calculations/comparisons together in that way. Quick Base is expecting something like:
IF([some field] comparison operators [comparison field or value], do this, else this)
With this statement - if % Complete is less than or equal to 10 compared to % Expected - is there another way you can state this? What do you mean by "compared to % Expected"? Are you wanting to show the yellow circle if the % Complete is less than the % Expected?
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------