Excel Formula to Alteryx transfer Assistance

Question

Hello, I know that the formula's used by Alteryx is slightly different than the ones we typically use in the realm of excel. I've been struggling with trying to get this excel formula to calculate for me within Alteryx and could use some help to figure out what I may be doing incorrectly. =IF([ACCOUNTING_PERIOD_END_DATE]>[Month_End_date],IFS($[ACCOUNTING_PERIOD_END_DATE]<[Month_start_date],0,$[ACCOUNTING_PERIOD_END_DATE]>=[Month_End_date],([Month_End_date]-[ACCOUNTING_PERIOD_START_DATE]+1)*$S14,$[ACCOUNTING_PERIOD_END_DATE]<[Month_End_date],($[ACCOUNTING_PERIOD_END_DATE]-[ACCOUNTING_PERIOD_START_DATE]+1)*[DAILY AMORTIZATION]),[Settlement Amount])

Luke_C · Answer

Hi @jasirmayat

Sample data would be helpful. That said, the 'IIF' function in alteryx is most similar to Excel: IIF(bool, x, y)

The alternative would be the IF syntax:

What have you tried so far?

jasirmayat · Answer

=IF([ACCOUNTING_PERIOD_END_DATE]>[Month_End_date],IFS($[ACCOUNTING_PERIOD_END_DATE]<[Month_start_date],0,$[ACCOUNTING_PERIOD_END_DATE]>=[Month_End_date],([Month_End_date]-[ACCOUNTING_PERIOD_START_DATE]+1)*[Daily Amortization],[ACCOUNTING_PERIOD_END_DATE]<[Month_End_date],($[ACCOUNTING_PERIOD_END_DATE]-[ACCOUNTING_PERIOD_START_DATE]+1)*[DAILY AMORTIZATION]),[Settlement Amount]) Forgot to replace one of the cells to the field name.