I want values ​​to be displayed simultaneously on both Workcenters

[Sxbbb]

I use this code OUF :

if(WorkCenter_QA='BLKO',QCNoticeNo,
if(WorkCenter_QA='CUPAT',QCNoticeNo,
if(WorkCenter_QA='CUPAV',QCNoticeNo)))

I use this code OUB :

if(WorkCenter_QA='SM',QCNoticeNo,
if(WorkCenter_QA='SMD',QCNoticeNo,
if(WorkCenter_QA='GP',QCNoticeNo)))

But there are two values ​​to display.

But the values ​​are not displayed in the table. OUF/ OUB

Workcenter_QA must be selected for the value to be displayed.

I want values ​​to be displayed simultaneously on both Workcenters.

[MayilVahanan · Accepted solution]

Hi

Try like below

MaxString({<WorkCenter_QA={'BLKO', 'CUPAT', 'CUPAV'}>} QCNoticeNo)

or

If you want both values, then try like below

Concat({<WorkCenter_QA={'BLKO', 'CUPAT', 'CUPAV'}>}Distinct QCNoticeNo , ',')