Mohd faizal Adris Posted April 3, 2020 Share Posted April 3, 2020 I have calculated column [Week] andwant to limitdata by showing the latest week as below expression; [Week]= Max(([Week])) AND [Category]="ABC" AND [Department]="123" After applying the expression, it returned (empty) as an output instead of sum total time. Anyone, can advise me on this Thanks. Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 3, 2020 Share Posted April 3, 2020 It looks like you do not have any records/rows which are intersected by the above three conditions and that's the reason for empty data. You can check this by simply using [Week]=Max([Week]) and you would get some results. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now