Average with Multiple conditions

[Venkatsj]

Hi,

Need help with the expression

Name	Status	Days
A	Distribution	3
A	Minor	5
B	Distribution	5
B	Minor	5
G	Vacation	3
D	Tour	2
E	Distribution	2

From the above table I wanted to calculate average number of days using "Days" Column. But using filter in Column "Name" = A, "Status" = Distribution & Minor. 

Please guide, Thank you.

[Tribhuwan]

Could you please help me with aggregate on below formula, I have a column ID which has duplicate values

Avg({<CALENDAR_YEAR = {'2023'}, STATUS = {'WON'}, BDE_FLAG = {'BDE'}, SALESTEAM_ROLE = {'BUSINESS DEVELOPMENT EXECUTIVE-DIRECT',
'BUSINESS DEVELOPMENT EXECUTIVE-INDIRECT'}, VP = {'AAAAA'}>}ARRPLUSAUEUR)

[AshutoshBhumkar]

The expression looks OK. It will be difficult to provide an answer without knowing the expected output.

Can you please provide sample data with expected output.

[Tribhuwan]

Hi Ashutosh

I am able to find the workaround but thanks a lot for sharing the formula otherwise I will not be able to solve it

[AshutoshBhumkar]

Thanks.

Please mark the answer correct if it was helpful.

[Tribhuwan]

Hi Ashutosh,

Could you please let me know how can I use OR in the below formula

Avg({<CALENDAR_YEAR = {'2023'}, STATUS = {'WON'}, BDE_FLAG = {'BDE'}, SALESTEAM_ROLE = {'BUSINESS DEVELOPMENT EXECUTIVE-DIRECT',
'BUSINESS DEVELOPMENT EXECUTIVE-INDIRECT'}, VP = {'AAAAA'}>}ARRPLUSAUEUR)

So basically I need either of the values in the formula.

Also can we include MATCH in it.