Jump to content

Calculation Graphic Switch


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

Recommended Posts

Change cTextValidate to:

If ( IsEmpty ( Text ) ; cContainer ; cContainer [ 2 ] )

When specifying repetitions, the first repetition is the default if left unspecified.

Link to comment
Share on other sites

Change calc type to text and it will change when the value changes. You have it as a number and that's why it doesn't work.

UPDATE: You can also apply color directly to a standard field by leaving it a standard field and applying your calc under the Auto-Enter tab, via calculation. After you enter your calc, UNCHECK 'Do Not Replace Existing Value' in the Auto-Enter tab. I prefer not to colorize my original text because printing can then look odd.

And you can shorten your calculation to:

If ( Item in Stock < Item Reorder Level ; TextColor ( Item in Stock ; RGB ( 255 ; 0 ; 0 ) ) ; Item in Stock )

You can use as many colors as you wish - just define them within the calculation ( using a Case statement etc).

Edited by Guest
Added update
Link to comment
Share on other sites

This topic is 6461 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.