Forum Discussion
Anonymous
6 years agoNot applicable
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
- HotChilliCommunity 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
- AnonymousNot applicable
Perfect thank you, it did indeed work. now I just target 0 as the filter 🙂