Expression problem

[#1]

=sum({$ < [Claim Desc] = ,[Claim Nature] = >}INSP_EVENT_CNT)  is use to find out the total and it works

I want to add a column to count where the insp_type_desc is material

Any suggestion? I am not familiar with using analysis, thank you!

[arulsettu · Accepted solution]

may be this

sum({$ < [Claim Desc] = ,[Claim Nature] =,INSP_TYPE_DESC={'Material'} >}INSP_EVENT_CNT) 

[PrashantSangle]

Hi,

close {} and "" in your set analysis

sum({$ < [Claim Desc] = ,[Claim Nature] =,INSP_TYPE_DESC={"Material"} >}INSP_EVENT_CNT)

Regards

[manishnarang]

use INSP_TYPE_DESK = {'Material'} inside expresion

[#5]

I appreciate it, thank you so much!!!