Expression

[smilingjohn]

Hi All, 

I am trying to get the data based on row to row match comparing to fields , but along with set analysis 

the expression don show any error but this even doesn't give any out put also , Can any one please help me in correcting my expression 

=if(Product=SubProd,
count(Distinct{<STATUS_NAME-={'Delivered'},
SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if(CREATE_DATE>IntDate , ID)))

Thanks

[MarcoWedel]

can you please post some sample values and your expected result as well?

thanks

[Vegar · Accepted solution]

Your issue can be casued by many things, it's hard to pinpoint whitout more details.

However, my first thing to check would be the result of Product=SubProd. If you have more than one Product and SubProduct per calculation you will run into issues.

It this is the issue then you might  be able to do a workaround using this expression.

=count(Distinct{<STATUS_NAME-={'Delivered'}, SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if((CREATE_DATE>IntDate) AND (Product=SubProd) , ID))

[smilingjohn]

Thanks a lot Vegar you rock man ✌️