In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

How can I get the output values only Multiple of 5

munipavankumar
8 - Asteroid

I need an output values that are multiple of 5. I have attached the picture for your reference.

Can any one please help!!!. Thanks

Screenshot 2023-12-28 152623.png

2 REPLIES 2
TimN
13 - Pulsar

Hi,

I think the Mod function can do what you want.  Here is an example.

aatalai
15 - Aurora

@munipavankumar you could also use the filter tool with the following condition

 

If isinteger( [score]/5) then "True" else "False" endif

Labels
Top Solution Authors