
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rounding up
Hi - I have a straight table and calculating % compliance. I also want to calculate the amount of reviews needed to achieve compliance at 92%. So, I've started calculating this in columns within the tables. All working OK, until I need to add the final column which basically rounds UP column 6 to nearest whole integer but ONLY if the number if greater than zero. If less than zero, I'd like it to not be displayed to be honest, so only showing those integers above zero and as a rounded up number. Many thanks.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(yourcalc > 0, round(yourcalc), '')
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
James, did Rob's post help you get what you needed? If so, be sure to use the Accept as Solution button on his post to give him credit and let others know it worked. If you are still working on things, leave us an update, so we can try to see if anyone can come up with something else that may work.
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
