Hi all,

I am trying to make a field which displays this:

48 x 180 (8,640)

But I'm getting this (no separators):

48 x 180 (8640)

Here's the code I'm using:

TEXT(Lot__r.Unit_Count__c) & " x " & TEXT(Lot__r.kg_unit__c) &" (" & TEXT((Lot__r.Unit_Count__c * Lot__r.kg_unit__c)) & ")"

Is there a simple way to insert comma separators in TEXT numbers - or perhaps a better way to do this? I am stumped and think the only way must be to write some combination of RIGHT and TRIM statements - or something else? This must have come up before, right?

It's easy in APEX:

<apex:outputText value="{0, number, ###,###,###,###}"><apex:param value="{!Quote.Total_Price__c}"/></apex:outputText>

...but does not work in formula fields.

What am I missing? Thanks much for any help.

Alex