Hi there, I have a summary field that gives the total amount for an invoice, pulling details from a portal. I am unable to keep the formatting of my retail fields (with the comma and .00). Screenshot attached.
Is there a way around this? I have tried a calculation list but that only returns the first artwork in the portal.
If your summary field summarizes a number field, you should be able to select it while in layout mode and then use data formatting from the Inspector to specify the desired numeric (and currency) formatting.