Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

FX Calculation

stephen
5 - Atom

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))

1 REPLY 1
binu_acs
21 - Polaris

@stephen one way of doing this

image.png

Labels
Top Solution Authors