When I select currency for a numeric field, FMP always shows me % which of course isn't what I want or expect.
I must be missing a config setting.
Thanks in advance,
Well, not exactly what one would expect. I wonder if the logic would be to use whether the symbol from the computer or file as per settings for the file. But then which country would use %as the currency symbol ?
Exactly. No country uses % that I can see.
XE - World Currency Symbols
I was "assuming" that FMP was smart enough to know (or determine) basic settings (or via a configuration issue I didn't set or something) to know what country I'm in and display $.
Java, for example, with no explicit configuration by me, works with various Locales... it's a built-in System (static class) property.
So (from the command line...):
Therefore '$' should be displayed in FMP.
Why doesn't FMP have this basic capability?
I wonder if it was one of those default-set-before-hosting. Try to click no where (no field, text, or object) in layout mode. Then set the currency as desired. Save layout (even though nothing has changed). Close the file and see if it persists when opened again. If hosted, it may or may not stick. I was annoyed that I had currency for each new number field until I "cleared it up" this way!
Just a local copy of FMP 16 Adv.
If I click where there is no field, then the drop down with currency is disabled.
You'd think that even if the FMI developers didn't take the time to look up (or even think about...) locale info ("US" -> "$" for me) that after I'd set the currency to "$" 50 or so times, FMP just might catch on, right? Nope.
Thanks for your reply.
OK! I created a new file one field 'anynumber'. On the layout with the field still selected, I choose Currency and change the $ to %. I quit the file.
I open the file and click anywhere (in Layout Mode) and Currency has the %. I change it to $. And close the file.
I open the file again and the Currency has the $. The field (which was a manual change) still retains the %, but the "default" Currency still has the $.
I found Currency with % only attached to the one field on the layout.
Thanks Bev, but I can't believe such (undocumented) gymnastics are required of the user to get locale-specific (in this case) currency symbols.
This issue is clearly another FMP bug from my perspective and I'll add it to my 75+ missing features in FMP.
I can see that a “local” default can be set (as I did) that persists. I call it an over-ride (even if by carbon mistake). It’s a Format/Style, that like other styles may get customized by the user.
I have not tested to see, but it may be a file-based Style.
Sent from miPhone
Retrieving data ...