Leo Balzateri Posted April 10, 2020 Share Posted April 10, 2020 Dear all, I have the following issue : by Company, I want to display the First Internal model of the table below as displayed in the column 'Result of the custom expression' Could you please assist Car Company Version Model I/E Result of the custom Expression / Expected Output BMW 2 Series M External SPORT BMW 2 Series SPORT Internal SPORT Mercedes ML220 X Internal X CHEVROLET CAMARO Y Internal Y LAMBORGHINI AVENTADOR Z External - RENAULT CLIO RS Internal RS FERRARI 360 Modena COUPE External - AUDI Q3 RS External TT AUDI Q3 TT Internal TT AUDI Q3 SPORT Internal TT Regards, L. Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 13, 2020 Share Posted April 13, 2020 Use the following expression. It is working as expected at my end. SN(First(If([i/E]="Internal",First([Model]) Over ([Car Company]))) over ([Car Company]),"-") 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