Format Expression

[evansabres]

I have an expression that appears as:

= 'Quantity Available:    '     &   NUM(SUM(vTotalCapacity)-(NUM(SUM(num_seats),'#,###.')))

vTotalCapacity = 71950

I want my expected output to be formatted as ##,###, however I cannot get the expression to have that output, the result is formatted as #####, with no separator as I am attempting to do.

Have I structured this equation incorrectly?

[sunny_talwar · Accepted solution]

Try this

= 'Quantity Available:    '     &   Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')