I have a table that I am trying to change to a vertical format. The original has a dozen or so line items. My problem arises in that the different line items can have different formats for their amounts (Percent, Currency, etc.)
What is the best way to format the Amount field appropriately? I have found a custom function on the "Filemaker Custom Functions
" site, but that currently has an issue with the large numbers that I need to use (9+ digits). My other thought was Conditional Formatting, but that seems to only affect things like fonts, colors, underlining, etc.
Is there a way to format (Data Formatting section) a number conditionally? (Number, percent, numbers of decimals, etc)?
If, that doesn't address it, respond with more detail and examples, especially about the source of the data and whether we're talking about number or calculation fields.