Forum Discussion

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago
Solved

Exclude only one value from filtering

Hi Guys, I have 2 linked tables. the first has the time in minutes spent for the FTEs for all the services provided: Time Services m Office Service 1                              206 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    You could always add a condition to your calculations which could be: Time[Services]<>"Service 6"

     

    This sets a condition for your calculation, which makes sure it always excludes service 6.

     

    If I misunderstand your challenge, please let me know and elaborate.

     

    Best,

    Martin

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi CiuCiCiao

 

Don't worry :smileyhappy: I'm going to be at the office in a couple of hour, and I will come up with something for you by then :)

CiuCiCiao's avatar
CiuCiCiao
Helper I
9 years ago

AnonymousI would love you so much!

But since is it is 08 GMT, wherever you are in the world is Saturday, why are you going to the office? :smileyfrustrated:

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    CiuCiCiao I love my job :smileyvery-happy: I run my own business, so I don't really have working hours. I'm always at work. And my girlfriend will join me, so don't worry I am in contact with other people as well :smileyvery-happy: