Has anyone else had trouble with the 'NumberFormat'?

I have a simple table with 3 columns, 1 of which contains 'Amount'. The source data is formatted as 'Number' in Excel and the import step correctly has the column identified as a #. I'd like the table to reflect a number format of #,###.and (#,###.) for negative values. My formula is:

=NumberFormat({Amount},"#,###.#;(#,###.#)",negColor="Red")

but it's not working for all values, only the negatives it looks like?

@Stephanie Geltrude, check out this post. I believe it has the answer you are looking for -- https://tbmcouncil.jiveon.com/message/22719

@Tony Wong you're correct, thanks for the link. NumberFormat only works on labels. So now I'm looking for a formula that formats my values as #,### while still allowing the values to SUM

@Stephanie Geltrude, check this article out -- https://tbmcouncil.jiveon.com/docs/DOC-5075. It looks like you need to use the currency function to format them in numeric value so you can do the sum.

I was thinking also that in the formula, you can first do the sum function and then do the NumberFormat function afterwards.

Hi, Stephanie!

Tony's solution above will work, if you're willing to convert your numeric values into strings (labels). However, this runs the risk of losing a lot of analytical functionality (e.g., maths) later on. Have you tried applying a perspective to the report? Perspectives generally have a specific formatting they use for numeric values. One caveat is that a perspective is applied to the whole report, not just to one field.

When I stumbled over the same problem, I started using (creating) metrics, where you can set the same format as you mention.
Maybe you give this a try?