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

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. 

1 REPLY 1
danrh
13 - Pulsar

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

image.png

Labels