EXCEL FORMULA

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?

Transformation

Accepted answers

Bren_Spill2

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

All comments

Bren_Spill2

binu_acs

@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 @binu_acs

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335