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