tag:blogger.com,1999:blog-3998628784041768080.post7999668408433819786..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Tableau Tip Tuesday: Using the Modulo Function to Conditionally Format NumbersVizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3998628784041768080.post-58218761060480326812017-05-17T19:23:54.619+01:002017-05-17T19:23:54.619+01:00helpful tips!helpful tips!Anonymoushttps://www.blogger.com/profile/07784440528966983006noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-52174836133798877682017-05-16T20:29:12.177+01:002017-05-16T20:29:12.177+01:00Ah good one there Jonathan! Ah good one there Jonathan! VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-17745573514691871892017-05-16T19:40:05.601+01:002017-05-16T19:40:05.601+01:00Nice tip! I've sometimes run into problems wit...Nice tip! I've sometimes run into problems with calcs using the modulo function (as in the underlying data source can't compute them), an alternative formula that doesn't require modulo would be IF ([Profit Ratio]*100)-INT([Profit Ratio]*100)= 0 THEN [Profit Ratio] END. The idea here is that if the (value - rounded down value) equals 0 then the value must be a whole number.<br /><br /Anonymoushttps://www.blogger.com/profile/07246437048304077347noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-71927508965373332772017-05-16T15:59:34.944+01:002017-05-16T15:59:34.944+01:00Just to finish it off, you can apply the same logi...Just to finish it off, you can apply the same logic in to tool tip as well!<br /><br />Profit Ratio: MBhttps://www.blogger.com/profile/17645299830146382645noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-11494328679649257942017-05-16T15:55:41.125+01:002017-05-16T15:55:41.125+01:00Thanks, Andy! Works like a charm. I was not famili...Thanks, Andy! Works like a charm. I was not familiar with the Modulo function. Seems like it could be helpful in a number of ways. Anonymoushttps://www.blogger.com/profile/07503877057648346002noreply@blogger.com