filtering in GL Function

Hi its Friday and my brain is not working at all, I am trying to get Rows of account numbers using segments in GL function. I was wondering how i can add a condition where it returns only active account numbers which can be found in active column of GL00100 table.  

this is the formula that i have to return the account numbers using segments 


which will return this. 


Please sign in to leave a comment.