Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Capture Rows That Are Increments Of 5 Only

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

  • 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

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    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's avatar
      Anonymous
      Not applicable

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