Vaule formatter dynamic value

I have a new dashboard I am creating to summarise Azure costs. I am using the Costs Management - Scalar tile to show a $ amount of this group of resources. I would like to format this number to have a comma in the figure so it can be easily read:

Instead of a figure 123456.78 USD I would like this to be displayed as 123,456.78 USD

Does anyone know of a formula that I can use in the value formatter section that can convert this figure to having a comma?