topic Re: How to change to dollar amount with text object using sum of two fields? in QlikView

How to change to dollar amount with text object using sum of two fields?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am having an issue with trying to get the format of my expression in the text object box to result in a dollar amount ($) opposed to a decimal.

Here is the expression I am using:

=Sum([Queried Fin.Impact]) + Num(Sum([Non Queried Fin. Impact])

The result is a decimal rather than a dollar amount.

Any help would be appreciated!

Thanks,

Erin

Peter_Cammaert — Thu, 09 Nov 2017 17:41:51 GMT

Use the Num() function but put it around the entire expression, not just the end part.

=Num(Sum(...) + Sum(...), '$ #0.00')

Best,

Peter

ziadm — Thu, 09 Nov 2017 19:15:57 GMT

=Num(Sum([Queried Fin.Impact]) + Sum([Non Queried Fin. Impact]),'$#,##0.00')

Anonymous — Fri, 10 Nov 2017 19:59:20 GMT

Thank you both so much!