Can I display numerical field as a percentage in FileMaker?

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #116459

Can I display numerical field as a percentage in FileMaker?

qa-featured

 

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.

Related Questions