
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count
Hi Guys,
I have a requirement to be able to count the number of Orders where two conditions occur.
for Instance
the Number of Orders 'POMS' where the below conditions occur.
sum(IF(OF_PA_Status='Approved by Customer',(IF(MSTATUS='R4',1,0)),0))
so I am thinking
Count([POM](IF(OF_PA_Status='Approved by Customer',(IF(MSTATUS='R4',1,0)),0))
Would this work ? as a measure in the app, not in the script as a expression.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or may be this
Count({<POM = {"=OF_PA_Status = 'Approved by Customer' and MSTATUS = 'R4'"}>} [POM])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe use Set Analysis :
Count ( {< [OF_PA_Status] = {'Approved by Customer'}
[MSTATUS] = {'R4'} >}
[POM] )
Note: Above typed freehand so may well have a typo in it.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this -
Count({<OF_PA_Status={'Approved by Customer'},MSTATUS={'R4'}>}[POM])

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or may be this
Count({<POM = {"=OF_PA_Status = 'Approved by Customer' and MSTATUS = 'R4'"}>} [POM])
