malak rihaili Posted February 10, 2021 Share Posted February 10, 2021 Hey Guys, I'm trying to show when the las time that a specific well has an Operating status ( to show for how long it was shut in) I have used this formula but it is not working Last (WHEN ="10" OVER [W_GNR_NAME]) code 10 simply means operating your help is appreciated Thank you Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 12, 2021 Share Posted February 12, 2021 Presumably you have a date column I am not completely clear how you wish the result to be. Something like this would give you a date and it would be set for every row to the maximum value of [YOURDATE] for each [W_GNR_NAME] when is 10. If [code] is never 10 then it is null for that well. Max(case when [code]='10' then [YOURDATE] end) over ([W_GNR_NAME] Link to comment Share on other sites More sharing options...
malak rihaili Posted February 17, 2021 Author Share Posted February 17, 2021 thank you so much ! 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