Format as a Number

[evansabres]

I have an expression

=NUM(SUM(transTOTALSALE),'#$,###.##')+ NUM(SUM({$<transTYPE={"RETURN"},}>}transQUANTITY * transBASEPRICE),'$#,###.##') - projREV

I want this result to be shown as a dollar amount. However, the result is just displaying as 33980 as opposed to $33,980.

Do I have the structure of the expression incorrect?

[krishnacbe]

Try below expression.

=NUM((SUM(transTOTALSALE)+ SUM({$<transTYPE={"RETURN"},}>}transQUANTITY * transBASEPRICE ) - projREV,,'#$,###.##')

[evansabres]

When I enter this into the expression dialogue box, I get a message of 'Error in Expression'

[krishnacbe]

Sorry there was a Typo. Try below

=NUM((SUM(transTOTALSALE)+ SUM({$<transTYPE={"RETURN"}>}transQUANTITY * transBASEPRICE ) - projREV,'#$,###.##')

[its_anandrjs]

Try to add this

=NUM(SUM(transTOTALSALE),'USD #,##0.00', '.',',')+ NUM(SUM({$<transTYPE={"RETURN"} }>} transQUANTITY * transBASEPRICE),'USD #,##0.00', '.',',') - projREV

[krishnacbe · Accepted solution]

=NUM((SUM(transTOTALSALE)+ SUM({$<transTYPE={"RETURN"}>}transQUANTITY * transBASEPRICE )) - projREV,'#$,###.##')

[evansabres]

Thank you

[krishnacbe]

or

=NUM((SUM(transTOTALSALE)+ SUM({$<transTYPE={"RETURN"}>}transQUANTITY * transBASEPRICE )) - projREV,'$#,##0.00')

[jduenyas]

Why do you have the extra # in front of the $ sign. That messes up the formatting.

NUM(SUM(transTOTALSALE),'#$,###.##')+...

Having said that, the other reply is correct . NUM( expression + expression +... 'FORMAT')

You may also NUM(Expression,'FORMAT') + NUM(Expression,'FORMAT') + ... but it is not necessary and takes longer to process.