We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Round Certain Values to a factor of 6

thelegazy
7 - Meteor
‎02-01-2018 12:54 PM

Hi All,

 

I need to be able to round values based on a certain criteria (Product Type: XYZ) to be divisible by 6. 

 

Does anyone have any experience with this? 

 

Any information would be greatly appreciated. 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
danrh
13 - Pulsar
‎02-01-2018 01:20 PM

Round([Field],6) in a Formula tool will round to the nearest multiple of 6.  Is this what you're looking for?

image.png

Reply
0 Likes
Community Live
Labels
Top Solution Authors
View All