Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 3347 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

i have a portal filed that has two conditions.

if value is >10  calculated percent difference is old value +/- 10% returns green

if value is <10  calculated percent difference is old value +/- 1 returns green

if outside range returns red.

i have tried case conditions and the formatting works for the <10 condition only.

thank you all in  advance565f0ca65fd17_ScreenShot2015-12-02at10.2                    565f0ce67f1c2_ScreenShot2015-12-02at10.2

Posted
26 minutes ago, skip mckee said:

if value is >10  calculated percent difference is old value +/- 10% returns green

if value is <10  calculated percent difference is old value +/- 1 returns green

if outside range returns red.

That's very difficult to understand. Is there a situation where the field should be neither green nor red? If not, you have only one condition.

This topic is 3347 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.