Excel formula replicate in alteryx

Question

Hello All,

I had some urgent critical requirement to be deliver where i need to automate and replicate the excel calculations in Alteryx. Below is the formula.

=IF($AU12="Y", IF($AY12="Y",perAmort($AJ12,$BC12,$BE12,BQ$2,BQ$3),0),IFNA(VLOOKUP($L12,'C:\Users\Desktop\2024\Excel\[DEL DATA.xlsx]qry___get_Data_for_Review___Ful'!$B$2:$X$76866,BQ$1-1,FALSE),0)*$AJ12)

In the above excel function used perAmort which is not available in Alteryx

as per the column mentioned above

AJ indicates 'Amount'

BC - Beg month

BE - End month

BQ- Fiscal year dates

Screenshot 2025-02-08 112008.jpg

ntakeda · Answer

@gantanvesh

perAmort appears to be a user-defined function.
It is not included in the attached Excel file.
Therefore, it does not work as shown below.

The best course of action would be to check with the creator of this Excel file first.
After that, if you have any further questions, please post them again.

gantanvesh · Answer

Hi

Attached the sample data for reference. Need help in understanding how the formula is working in excel to replicate in Alteryx.

Calculated columns starting from column BQ.

tos sam.xlsx

AshRez · Answer

The request seems to be unclear and I was not able to find any formula in Excel called "PerAmort".

It will be better that you describe the situation and what you need to accomplish, with as much details as possible. Maybe example files too.

The formula you provided was even pointing to columns that no description of what it is, and some pointing to a data on another file.