Alteryx Designer Desktop Discussions

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

Calculate variance between two update fields

wendyzjy
8 - Asteroid

hi Experts,

I would like to calculate the variance between two monthly update columns, for example, in my workflow, there are "total amount" field, in Aug, I would like to calculate the total amount minus June 2022 field, then in Sept, there will be a new column "July 2022", and I would like to let this total amount field auto calculate variance with July 2022's value. Is it possible to just use a formula tool? Hope could get your help on this. Thanks!

1 REPLY 1
Biswarun
8 - Asteroid

That excel sheet is in a God-awful format. Sure about the input? And I cannot understand what you want to obtain.

Labels