Count with multiple conditions

[mikegauntlett]

Hi

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.

[jaumecf23]

Try this:

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

[mikegauntlett]

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

[jheasley]

give this a shot:

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