Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Chart that I have turned into a drop down list.
There is a selection box that allows for me to set the Chart to one "Alternate State".
I would like the Chart to respond to more than one 'Alternate State'
=num(count({<legproject=$::LegProject,LegSourceType=$::LegSourceType,LegProject='CAPA','Product Complaint','Evaluation','Data Source','Deviation','OOS','EMIR','VSCR','UIR','Assessment','Change Source'}>
+<LegProject=$::LegProject,LegSourceType=$::LegSourceType,LegProject={'Observation'}, LegSourceType={'GMP Quality Compliance','Regulatory Agency'}>} DISTINCT LegRecordID), '#,##0', '.' , ',' )
I am getting an "error in set modifier expression"
Should I use 'or' instead of ','?
My mistake, a typo. There should be an opening curly bracket in LegProject='CAPA' between the = and 'CAPA'.
=num(
count({<
ProjectType=$::ProjectType,
SourceType=$::SourceType,
LegProject={'CAPA', 'Product Complaint', 'Evaluation', 'Data Source', 'Deviation', 'OOS', 'EMIR', 'VSCR','UIR', 'Assessment', 'Change Source'}
>
+
<
ProjectType=$::ProjectType,
SourceType=$::SourceType,
LegProject={'Observation'},
LegSourceType={'GMP Quality Compliance', 'Regulatory Agency'}
>}
DISTINCT LegRecordID
),
'#,##0',
'.',
','
)
If your question is now answered, please flag the Correct Answer and Helpful Answers to close the topic.
If not, please let us know what part of this topic still needs answering .