Text Object requiring dollar sign output

[#1]

Hi all - For some reason I cannot get any permutation of the below formulas to output as a dollar sign representation -- this is for a Text Object. If I dont do subtraction (just the vEstimateTotalCost, for example), then the dollar sign and two decimals render fine. I have tried at least 3 different ways to construct this as shown below and I am always getting a value like 123456.333333333. The right value IS always returning for each of these, but I do need it to be $ and two decimals, like $123,456.33

What am I doing wrong? Thanks smart people!

=num(sum([Original Rev Est]), '$###,###.00') - num($(=$(vEstimateTotalCost)), '$###,###.00')

=num(sum([Original Rev Est])) - num($(=$(vEstimateTotalCost)), '$###,###.00')

=num(sum([Original Rev Est]),'$###,###.00') - num($(=$(vEstimateTotalCost)))

[sunny_talwar]

You need a Num function around the whole expression:

=Num(Expression1 - Expression2, '$###,###.00')

[MarcoWedel · Accepted solution]

formatting numbers you are calculating with afterwards does not make sense because the format is removed during the claculation.

Like Sunny already proposed, you have to format the result instead:

=num(sum([Original Rev Est]) - $(=$(vEstimateTotalCost)),'$###,###.00')

hope this helps

regards

Marco