Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
= 'Quantity Available: ' & Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')
Try this
= 'Quantity Available: ' & Num((Sum(vTotalCapacity) - Sum(num_seats)), '#,###.')