Summary Number with 2 metrics needing commas and rounding
I am trying to make a Summary Number for a card with a calculated field that will look like this:
1,121 Loans | $211,100,123
or even better, if possible:
1,121 Loans | $211.1M
The first number could be anywhere from 5 to 500,000. The second currency number could be anywhere from $10,000 to $1 Billion dollars.
My current formula is:
Concat(COUNT(`LoanAmount`), ' Loans | $',
The result looks like this:
1121 Loans | $211100123
How can I get the desired format in there?
Thanks in advance