This content has been marked as final.
Show 3 replies

1. Re: Calculating Total Percentage
Shinichiro Murakami Mar 16, 2016 3:30 PM (in response to Eric Horio) 
2. Re: Calculating Total Percentage
Eric Horio Mar 16, 2016 4:19 PM (in response to Shinichiro Murakami)Thanks! I'm also trying to "color code" the % Kept that is >= 90% Green. I tried using this formula, but I keep getting an error:
IF [% Kept] >=90% then "Green"
ELSE "White"
End
Do I need change the expression ( like something before the %kept, or is the formula incorrect ).

Problem Template.twbx 129.1 KB


3. Re: Calculating Total Percentage
Shinichiro Murakami Mar 16, 2016 5:35 PM (in response to Eric Horio)Correct
if [%Kept (copy)] >= .9 then "Green" END
Incorrect
if %[%Kept (copy)] >= 90% then "Green" END
"%" has different meaning in the formula.
% (modulo)
This calculates a numeric remainder. For example,
5% 4 = 1
.