Syntax Help

[cbaqir]

I have a requirement to show avg number of days from when a generic build resource is populated to when a named resource is populated.

Generic resources = RESOURCE with a  "_" in the name like charges_builder.

Requirement: IGNORE generic name of ccl_consult

Requirement: if no "_" (generic) resource, use start date of COMMITTEE_CAT = "ERC - Assigned" to first date name is populated

One DEFECT_ID could have multiple generics or multiple names for each RESOURCE_TYPE

For example, DEFECT_ID 10811 should show the avg days from ClinDoc Resource and Primary Assignee (even though both happen to be the same name here). I would like to see two values since there are two RESOURCE_TYPES and is should count from the 7/31 date NOT 7/19.

How do I write the expression to give me the time that a specific RESOURCE_TYPE went from generic to named?

Thanks!

[cbaqir]

Not sure I understand the question. There are several resource type fields.

[cbaqir]

Ah - I want to use the right one. I thought it was Fact but maybe it's DM.

[cbaqir]

Please see updated requirement for clarity:

Requirement: IGNORE generic name of ccl_consult

Requirement: if no "_" (generic) resource, use start date of COMMITTEE_CAT = "ERC - Assigned" to first date name is populated

[cbaqir]

stalwar1‌

[cbaqir]

bump