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!
That excel sheet is in a God-awful format. Sure about the input? And I cannot understand what you want to obtain.