Hello:-)
Let’s say I have a column of 1000 numbers. In the column I have random numbers and I would like to find numbers which can be found in a series of 5.
For example:
2, 5, 24, 3, 69, 37, 1, 45, 62, 65, 90, 13, 17,14, 4, 9… and I would like to end up with: 5, 45, 65, 90 (one serie) and 4, 9, 14, 24 (the second serie).
Is there an easy way how obtain desire results?
Amanda
Hi @Amanda252 , this is easily achieved using the mod() function from the Math Formula:
You can do:
mod($your column$, 5)
This will give you the remainder when dividing the values from your column by 5.
For example:
mod(10, 5) = 0
mod(1, 5) = 1
mod(24, 5) = 4
mod(69, 5) = 4
etc
You can then filter on this result and filter by 0 and 4.
Those with 0 will be the series for multiples of 5, and will give you numbers like 5, 45, 65, 90.
Those with 4 will be the series with remainder of 4 when divided by 5, and will give you numbers like 4, 9, 14, 24.
3 Likes
Hi @Amanda252 , here’s something I put together for you:
Input:
Math Formula:
Expression: mod($column1$, 5)
Results:
From there, you can filter out anything that’s not 0 or 4:
I’m using the Rule-based Row Filter as you can see, and the expression is:
$remainder$ IN (0, 4) => TRUE
Results:
I can now split between 0 and 4 using the Row Splitter:
Final workflow looks like this:
Top Series:
Bottom Series:
2 Likes
Thank you very much for your help. It works perfectly. Thanks
3 Likes
system
Closed
October 16, 2022, 3:08am
5
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.