Can I display numerical field as a percentage in FileMaker?

Asked By Jamie Fabio 10 points N/A Posted on - 03/29/2012

I calculated as: If(PO Income flag="Yes";"Annual Income @" & Income::Maximum Income ;Resale Information).
The Income::Maximum Income display as "Income @ 0.521" but I would like it to display as "Income @ 52.1%". Keeping in mind that text is kept in my calculation to display Income. I need some help.

• Status: Open
• Question Views: 903
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Ratyr patsr 0 points N/A #116459

Can I display numerical field as a percentage in FileMaker?

 

The syntax seems to be a bit wrong. Where are the semicolons and that when you need to put the % mark, then you have to take another text where you have to concatenate this number to the string. This is not practically possible. In fact, the number has to be converted to string first and then concatenated to the text with “%” mark. This is the main reason to the programming error. You will have to put number in separate variable and a text in other one. Both are not possible through one variable.  Hence you take two variables once for number and other for the % mark. This will do. Thanks.

About Ratyr patsr

Questions
0

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 06/09/2012
• Question Category: Misc Software