AnsweredAssumed Answered

let function direction

Question asked by bookalaka on Feb 10, 2018
Latest reply on Feb 14, 2018 by beverly

Hello,

 

I have been trying to understand the "let function" and need direction if this what I should be trying to use.

 

Trying to make a solution from multiple records with the same product number and list the critic review in one field.

The amount of records vary as well as the reviews.

 

This is what I am trying to achieve;

 

       

Record IDItem CodeSCORERESULT I WANT - CALCULATION TO COMBINE ALL RESULTS
1LGD10092PTS ROBERT PARKER 92PTS ROBERT PARKER, 93 WINE ENTHUSIAST, GOLD MEDAL
2LGD10093 WINE ENTHUSIAST92PTS ROBERT PARKER, 93 WINE ENTHUSIAST, GOLD MEDAL
3LGD100GOLD MEDAL 92PTS ROBERT PARKER, 93 WINE ENTHUSIAST, GOLD MEDAL

 

 

Will I need to use a script or a calculation can make this work?

 

Thanks for help.

Outcomes