Jump to content
Sign in to follow this  
mtpaper

Conditional Numeric formatting?

Recommended Posts

I can't imagine this is possible, but, I see the topic here, so I'll ask.

I have a table that defines various terms for paying royalties. Basically, it's set up as:

person

Rate type (value list: fixed, percentage)

rate Amount (such as $1675 and 3.875%)

Now, I know very well that the rate amount can happily hold 1675 and .03875

But, when I print the report for anyone, they need to see the info as $1675 and 3.875%

Suggestions?

I looked at Format->Conditional and that helps me a bit... I could make anything > 10 be formatted in bold, for example... but that isn't ideal.

Thank you !

Share this post


Link to post
Share on other sites

Let me try to be clearer with my question.

I know how to format a field.

However, I want the format of the field to vary, depending on the contents of another field.

I want the format to be % if the Rate Type is percentage

I want the format to be currency if the rate type is "fixed"

Share this post


Link to post
Share on other sites

Let me try to be clearer with my question.

That always helps... ;)

No, it's not possible. You will need to add a calculation field with a text result, and do your own formatting there. Or use two separate fields to begin with.

EDIT:

Maybe this can work for you: put two instances of the same field on the layout (overlapping), and format them conditionally to shrink to font size 1 if the record is not their type.

Edited by Guest

Share this post


Link to post
Share on other sites

Hello -

Your solution is very clever, and works perfectly and I can't well to tell my husband (who works in Approach) that we solved it.

I knew there had to be a way -

Thank you for 'thinking outside the box' with me -

Marion

Edited by Guest

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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