Mohd faizal Adris Posted April 3, 2020 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.
Shashank Gurnalkar Posted April 3, 2020 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.
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