Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number format

Hi

I am using the follwing formula to format a nr :

=num(sum(SALESPRICE),'$#,##0')..it returns for example 2,354,874

How can I get rid of the hudreds  and round it as well. so it returns 2,354..

Thxs

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

=num(round(sum(SALESPRICE)/1000),'$#,##0')     would return 2,355

=num(floor(sum(SALESPRICE)/1000),'$#,##0')     would return 2,354

View solution in original post

1 Reply
m_woolf
Master II
Master II

=num(round(sum(SALESPRICE)/1000),'$#,##0')     would return 2,355

=num(floor(sum(SALESPRICE)/1000),'$#,##0')     would return 2,354