I want values to be displayed simultaneously on both Workcenters

Sxbbb — Fri, 15 Nov 2024 21:29:48 GMT

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.

Re: I want values to be displayed simultaneously on both Workcenters

MayilVahanan — Fri, 11 Aug 2023 09:05:27 GMT

Try like below

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

If you want both values, then try like below

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