topic Re: Count with multiple conditions in App Development

Count with multiple conditions

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

On a previous occasion I was given the below format

count({<OF_POM_Number= {"[Today_Exp_Del_Date_Opp]='<28' AND [OF_Install_Work_Order_Id_Key] = ''"}>}[OF_POM_Number])

To count the number of [OF_POM_Number] where the [Today_Exp_Del_Date_Opp] field equals less than 28 and the [OF_Install_Work_Order_Id_Key] is blank.

Everything looks okay when I enter the expression however it does not generate the count, it always equals 0 when I know in my dataset there should be hits.

Any Advice is greatly received.

Re: Count with multiple conditions

jaumecf23 — Mon, 07 May 2018 10:31:03 GMT

Try this:

count({<[Today_Exp_Del_Date_Opp]= {"<28"}, [OF_Install_Work_Order_Id_Key] = {''"}>}[OF_POM_Number])

Re: Count with multiple conditions

mikegauntlett — Mon, 07 May 2018 10:44:11 GMT

I'm Afraid not both instances either > or < = 0

Re: Count with multiple conditions

jheasley — Mon, 07 May 2018 18:31:19 GMT

give this a shot:

Count({$<Today_Exp_Del_Date_Opp={">$(=28)"},OF_Install_Work_Order_Id_Key={''}>}OF_POM_Number)