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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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