topic Re: Count in App Development

Count

mikegauntlett — Wed, 22 Dec 2021 15:42:54 GMT

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.

Anonymous — Fri, 30 Mar 2018 12:31:55 GMT

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.

Digvijay_Singh — Fri, 30 Mar 2018 12:33:03 GMT

May be this -

Count({<OF_PA_Status={'Approved by Customer'},MSTATUS={'R4'}>}[POM])

sunny_talwar — Fri, 30 Mar 2018 12:35:51 GMT

Or may be this

Count({<POM = {"=OF_PA_Status = 'Approved by Customer' and MSTATUS = 'R4'"}>} [POM])