Conditional Numeric formatting?

[mtpaper]

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 !

[comment]

Look at Format > Number… instead.

[mtpaper]

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"

[comment]

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 April 28, 2009 by Guest

[comment]

Here's a variation of the same idea - seems to be working.

ConditionalNumberFormat.fp7.zip

[mtpaper]

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 April 28, 2009 by Guest