bashar_f
Partner - Creator
2014-07-17
05:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to add a where clause to a variable definition
Hi,
I have a variable called vAdmissionsCount
The definition is supposed to be
count(emplid) Where prog_action = ADMT or MATR
prog_action is a field, but when i enter the definition like this, I get red lines all over.
1 Solution
Accepted Solutions
tresesco
MVP
2014-07-17
05:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Count( {<prog_action={'ADMT','MATR'}>}emplid)
2 Replies
tresesco
MVP
2014-07-17
05:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Count( {<prog_action={'ADMT','MATR'}>}emplid)
PabloOrtiz
Partner - Creator
2014-07-17
05:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=Count( {<$(vAdmissionsCount)>}emplid)
you have to create de var with this value
prog_action={'ADMT','MATR'}