Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ekelley93
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
Peter_Cammaert
Partner
Partner

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

Like

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

Best,

Peter

View solution in original post

3 Replies
Peter_Cammaert
Partner
Partner

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

Like

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

Best,

Peter

View solution in original post

ziadm
Specialist
Specialist

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

ekelley93
Contributor III
Contributor III
Author

Thank you both so much!