FX Calculation

[stephen]

Hi Team

I need a simple work flow but not sure why its not working using formula bar

Attach is the excel and the formula which i need to build in alteryx 

I tried below and it works for Jan and Feb but Mar is showing zero

Jan=  Jan Mtd* Fx rate of Jan

Feb  Feb MTD* FX Rate of Feb

Mar ((Jan Mtd+Feb MTD+Mar Mtd)*[FX_Rate] of Mar )-( Jan+Feb))

[binuacs · Accepted solution]

@stephen one way of doing this