Forum Discussion

ThomasvP's avatar
ThomasvP
Copper Contributor
Jul 21, 2023

Railway construction km Filter

Hi All,

I’m working currently on a MS-Project File for Railway Construction.

In there I have 2 number fields for km start and km end. All activities have an entry in these two fields. How can I set a Filter which shows me all activities between km 6 and km 7.

Following Tasks as an example:

Task 1: km Start 5,5 km end km 10

Task 2: km Start 6,2 km end km 6,5

Task 3: km Start 6,7 km end km 8,0

Task 4: km Start 5,5 km end km 6,5

I can not just set a Filter in KM start greater than 6, there I would miss Task 1 and Task 4

And when I set a filter in KM end less than 7, than I would miss task 1 and 3.

Any support would be very helpful.

  • ThomasvP,

    This is what I get when I create a filter based on the Date Range filter. Does it not do what you want?

    John

     

     

  • John-project's avatar
    John-project
    Silver Contributor
    ThomasvP,
    Take a look at the Date Range filter and modify the fields as appropriate for your needs.
    John
    • ThomasvP's avatar
      ThomasvP
      Copper Contributor

      John-project 

      Hi John, 

      thanks for the support. I changed the Date Range filter accordingly but,

      when I sete the range filter from 6km Start to 7km End, will not schow the activities witch goes e.g. Start 5km to 10km. 

      How can I set a Filter witch includes these tasks also? 

       

      Many Thanks in advance,

      Thomas 

      • John-project's avatar
        John-project
        Silver Contributor

        ThomasvP,

        This is what I get when I create a filter based on the Date Range filter. Does it not do what you want?

        John

         

         

Resources