EXCEL FORMULA

[Sarath27]

EXCEL FORMULA
=IF($B$1="Sun",IF(AH4<0,-BC4*VLOOKUP(BJ4,'FX Rates'!$A:$C,3,FALSE),BC4*VLOOKUP(BJ4,'FX Rates'!$A:$C,3,FALSE))*3,
IF($B$1="Sat",IF(AH4<0,-BC4*VLOOKUP(BJ4,'FX Rates'!$A:$C,3,FALSE),BC4*VLOOKUP(BJ4,'FX Rates'!$A:$C,3,FALSE))*2,
IF(AH4<0,-BC4*VLOOKUP(BJ4,'FX Rates'!$A:$C,3,FALSE),BC4*VLOOKUP(BJ4,'FX Rates'!$A:$C,3,FALSE))))

ALTERYX FORMULA
IF [Day]="Sun" THEN (IF [Current Rate]<0 THEN -[Cost Today Amt.]*[FX Rate]*3
ELSE [Cost Today Amt.]*[FX Rate]*3 ENDIF)
ELSEIF
[Day]="Sat" THEN (IF [Current Rate]<0 THEN -[Cost Today Amt.]*[FX Rate]*2
ELSE [Cost Today Amt.]*[FX Rate]*2 ENDIF)
ELSE [Cost Today Amt.]*[FX Rate] ENDIF

Can you please confirm if below formula I have transformed is correct?

[Bren_Spill · Accepted solution]

Hi @Sarath27 - the formula is correctly written in Alteryx and won't give any errors assuming field names are all correct. It would be helpful to see a sample of your data in Excel to test the logic properly

[binuacs]

@Sarath27 The Alteryx formula is not correct, in the excel you are using the lookup formula, which is not in the Alteryx formula you created, for the lookup you need to use either join tool or find and replace tool

[Sarath27]

Hi @binuacs 

I already brought this value [Cost Today Amt.] through join tool only.