Convert Excel formula to Alteryx - FILTER FUNCTION in Excel

[Arcane]

Hi Folks,

What is the available formula function for the keyword 'FILTER' in Microsoft Excel.

With that, I am looking to convert the below formula for Alteryx executable formula.

=if(
and(
left
(Sheet1[Description],15)="Expenditure"),
calculate(
sum(Sheet1[Totals]),
FILTER(Sheet1,
Sheet1[ExpenditureType]=EARLIER(Sheet1[ExpenditureType])
),0
)

Thanks in advance :)

[saveeshkumar]

Hi @Arcane ,

Could you please provide sample data and output?

[binuacs]

@Arcane Not sure this formula can be done using only the formula tool, but I think you need more tool like summarize, filter etc to achieve the result in Alteryx