Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jworthulf
Creator
Creator

How to round numbers.... using the num() function in a text object.

I'm working on a dashboard & I need to show CYTD Sales in a text object.   The formula I'm using is working but now I need to round the number down.   Currently I have $69,181,750.6 I need to round this number to 69.2 MRoun

1 Solution

Accepted Solutions
sunny_talwar

May be just this

=Num(Round(Sum({<year=,month=,quarter=,_CYTD_Flag={1}>} [# Amount])/1000000, 0.1), '$#.0M')

or

=Num(Round(Sum({<year=,month=,quarter=,_CYTD_Flag={1}>} [# Amount])/1000000, 0.1), '$#.0') & 'M'

View solution in original post

6 Replies
sunny_talwar

May be like this

=Round(69181750.6/1000000, 0.1)

micheledenardi
Specialist II
Specialist II

Use Round() function.

round([CYTD Sales],100000)

after that yuo can divide by 1000000 to obtain 69.2MRoun

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
jworthulf
Creator
Creator
Author

Sunny,

Thanks for the help I appreciate the quick response.

John Worth

Upper Lakes Foods, Inc.

801 Industry Avenue, Cloquet, MN 55720

p.800-879-1265 ext. 4278 l f.800-238-6456

www.upperlakesfoods.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.upperlakesfoods.com_&d=AwMFAg&c=Y1FPPfdI3qXd_9qVC_KBeZmXgnMS0xZibNIJZa39qG4&r=xr1IuEKVGJ9RIIyJ5eVTKiT49Wq75UFOJssniuBA2QA&m=5MFduC0NPPBvAEuflC5Zr_fkVsJIXm41KiHfdan1oMY&s=TuZ90iSqXX2DozspS0AL3NHLxiPspL0rNP6_P9d13YU&e=>

<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.facebook.com_upperlakesfoods&d=AwMFAg&c=Y1FPPfdI3qXd_9qVC_KBeZmXgnMS0xZibNIJZa39qG4&r=xr1IuEKVGJ9RIIyJ5eVTKiT49Wq75UFOJssniuBA2QA&m=5MFduC0NPPBvAEuflC5Zr_fkVsJIXm41KiHfdan1oMY&s=Aw1vGtvVLIwF4QLTBDRKu-YpOaLWkhQfPTZGWqMJtzk&e=> <https://urldefense.proofpoint.com/v2/url?u=https-3A__plus.google.com_-26-2343-3BUpperlakesfoods_posts&d=AwMFAg&c=Y1FPPfdI3qXd_9qVC_KBeZmXgnMS0xZibNIJZa39qG4&r=xr1IuEKVGJ9RIIyJ5eVTKiT49Wq75UFOJssniuBA2QA&m=5MFduC0NPPBvAEuflC5Zr_fkVsJIXm41KiHfdan1oMY&s=HYJT8Mq9naGNSSO_e3t8ioOliXZgOgRCig3SNJ6u2Hg&e=> <https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_UpperLakesFoods&d=AwMFAg&c=Y1FPPfdI3qXd_9qVC_KBeZmXgnMS0xZibNIJZa39qG4&r=xr1IuEKVGJ9RIIyJ5eVTKiT49Wq75UFOJssniuBA2QA&m=5MFduC0NPPBvAEuflC5Zr_fkVsJIXm41KiHfdan1oMY&s=s2GiATMqqCz7RvEIaGaQK-MYexeQk_RIDa1u63lwCyQ&e=> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.pinterest.com_upperlakesfoods_&d=AwMFAg&c=Y1FPPfdI3qXd_9qVC_KBeZmXgnMS0xZibNIJZa39qG4&r=xr1IuEKVGJ9RIIyJ5eVTKiT49Wq75UFOJssniuBA2QA&m=5MFduC0NPPBvAEuflC5Zr_fkVsJIXm41KiHfdan1oMY&s=Ywe4h8zB3YcGvkoziicDm1toTq9XqfaQtp2745Jxqmg&e=> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_upper-2Dlakes-2Dfoods-2Dinc.&d=AwMFAg&c=Y1FPPfdI3qXd_9qVC_KBeZmXgnMS0xZibNIJZa39qG4&r=xr1IuEKVGJ9RIIyJ5eVTKiT49Wq75UFOJssniuBA2QA&m=5MFduC0NPPBvAEuflC5Zr_fkVsJIXm41KiHfdan1oMY&s=C1_s6vVFw30Xssy6lNfi_Oo5Tyntb6An1dx5ChAsvTo&e=>

jworthulf
Creator
Creator
Author

Michele,

Here's my current text , how would I incorporate your solution in the expression?

=num((sum({<year=,month=,quarter=,_CYTD_Flag={1}>} [# Amount])/1000000),'$##.0') & ' M '

= 69.2 M

sunny_talwar

May be just this

=Num(Round(Sum({<year=,month=,quarter=,_CYTD_Flag={1}>} [# Amount])/1000000, 0.1), '$#.0M')

or

=Num(Round(Sum({<year=,month=,quarter=,_CYTD_Flag={1}>} [# Amount])/1000000, 0.1), '$#.0') & 'M'

jworthulf
Creator
Creator
Author

Sunny,

Thanks both scripts worked like a charm.   Awesome!