13 Replies Latest reply on Jan 6, 2016 10:34 AM by skipmckee

# stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

in conditional formatting how do you show +/-15% and +/-0.2 standard unit?

• ###### 1. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

Use this in the formula"

Self > Self * 0.85 and Self < Self * 1.15

This gives you +/- 15%. Similar calculation will give you +/- 0.2 units.

HTH

Mike

• ###### 2. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

thanks

how do you show self+/-15%

how do you show self+/-0.2 units

• ###### 3. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

What do you mean "show"? Are you trying to show the values? Show an indicator that the value is within those bounds? What is your actual need?

• ###### 4. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

range self +/-15%

range self +/- 0.2 units

• ###### 5. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

i think i need to do the calculation in script.

the script needs to compare previous value +/- 0.2 units

then the formatting would show range +/-15% or +/-0.2

• ###### 6. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

You mean you need an onscreen indicator that lights up when the value is within that range? Is that what you're trying for?

• ###### 7. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

i think i have the formatting range correct

is it self +/-.15 for 15%? if so how do you compare self +/-0.2 units?

how do i create the comparison of field +/- 0.2 in script?

set field [calc; (variable +/-0.2)] ?

• ###### 8. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

Just typing "+/- .15" won't do anything. FileMaker's calculation engine won't know what to do with that.

What exactly do you want here? Are you trying to calculate a value and store it in a field (which is what your latest post says)? Or are you trying to format something onscreen to indicate that the value is within a range? Your question is way too vague for any decent answer at this point.

• ###### 9. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

i am actually trying to do both.

i believe i have the formatting correct and working. just checking to make sure it is correct.

for +/- 15%

value is between -.15 and .15 (green) ( do i need to add "self"?)

value is not between -.15 and .15 (red)

for +/- 0.2 units

value is between (-?) and (?) (green)

value is not between (-?) and (?) (red)

value is % of difference from previous value

the other question would be the calculation that creates value that compares new value with previous value to verify if new value is with in +/-0.2

• ###### 10. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

Make the field green to begin with.

Conditionally format so that when the following formula is true...

abs ( self ) > .15

...the field turns green.

the other question would be the calculation that creates value that compares new value with previous value to verify if new value is with in +/-0.2

This is a bit vague. The new value is or isn't in the range regardless of what the previous value was, so what "comparison" could possibly have an impact?

HTH

Chris Cain

• ###### 11. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

The .15 has to be multiplied by something in order for it to mean 15%. What is the baseline value? You have to indicate what that is. Between -0.15 and +0.15 only works if those are absolute values - in other words, you want to know if the value is literally between 0.15 and -0.15.

And again, 0.2 of what? These are relative values you're talking about, so they have to be normalized to some value.

• ###### 12. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

Good point. I was making the assumption that the field in question was just the percentage, not the result of the percentage calc.

Chris Cain

Extensitech

• ###### 13. Re: stupid question: in conditional formating formula how do you show +/-15% and +/- 0.2 standard unit?

thank you both for your time.

i think i got it.