Capture Rows That Are Increments Of 5 Only

[Anonymous]

Hi,

I have data like this:

date[datetime], count of days[int], ticket ref[int]

I want to put a flag on each row where it is an increment of 5, e.g. 5, 10,15,20,25 and so on. This can go into the hundreds so I wanted to make it dynamic.

Tried this:

if List.Contains({List.Numbers(5,500000,5)},[Days Idle]) then "true"
else "false"

That didn't work I am assuming because list.numbers won't work with list.contains as that requires the numbers to be split out.

Could someone please steer me in the right direction?

Many Thanks
POC

[HotChilli · Accepted solution]

I think you can use

Number.Mod(theColumn, 5)

 just test the result against 0.  If it's 0, then it's divisible by 5

[Anonymous]

Perfect thank you, it did indeed work. now I just target 0 as the filter 🙂