Adding a prefix to a number

Questions
1

G'day all,

I'm using Filemaker Pro 17 and I have a problem with the following.

I'm trying to get a field to display the result of the following;

O2_Number_1 - O2_Aiming_For

If the result is a negative, it will prefix the number with a minus symbol, and that's exactly what I want.

But if the result is a positive, I would like it to display a (+) symbol in front of the number and I can't figure out how to do it.

Any help would be appreciated.

Michael

2

Hi @MIchaelG

If your calculation field is a number type, then “+” won’t display because it’s not a legitimate part of an integer (whereas - is). Instead, you can change your calculation to text, or ideally create a second calculation field purely for display purposes (so you don’t alter your original calc).

Let’s assume your original calculation is called “theNumber” for arguments sake. This calculation would look something like:

if ( theNumber > 0 ; “+” & theNumber ; theNumber )

All this is doing is checking whether theNumber is greater than 0, and if it is, prepending a + symbol to the start. Make the result of this calculation field text.

1 Like
3

G’day mate,

I created a second field, using your advise and it worked.

Thanks for your help :slight_smile:

Michael

1 Like