topic Text Object requiring dollar sign output in QlikView

Text Object requiring dollar sign output

Thu, 19 Nov 2015 19:37:22 GMT

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)))

Re: Text Object requiring dollar sign output

sunny_talwar — Thu, 19 Nov 2015 19:57:57 GMT

You need a Num function around the whole expression:

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

Re: Text Object requiring dollar sign output

MarcoWedel — Thu, 19 Nov 2015 23:28:51 GMT

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