March 8, 201114 yr A curious thing: I have two number fields: originalPrice and currentPrice. The currentPrice was calculated via Replace Field Contents to show 15% off the originalPrice. In FileMaker, both of these fields were marked as "Currency", a fixed number of decimals (2), a dollar sign ($), and a thousands separator (,). This works fine in FMP. However, when I view it on the web (using the API for PHP), the originalPrice looks like this $1,234.33 and the currentPrice looks like this 1049.1805 I changed the currentPrice to a calculation field (number return), again marked it as "Currency" in the inspector, but this did not help. Anyone have any ideas? Thanks.
Create an account or sign in to comment