I trying to count for everyID_TransportationthoseUsers IDwhich correspond to required statuses (Status_A and Status_B).Then I want to sort table and exclude zeros. And i will have only cases when rule is broken.
If I select singleID_Transportationmy formula counts times when rule was broken correctly.
But when I select several transportation, formula returns overestimated value. I believe, this is because formula counts all ID_User ever matched both statuses, even if that ID_User doesn`t match them for this particular ID_Transportation.
Probably creating a new field assumes using Data Loading Editor, but I never done it before and dont know how. Maybe you can send me link to some tutorial, so I learn faster? My data loaded from OLE DB, I converted it in SSMS.