How would I insert a row which is the variance between two other rows?

lhongo
lhongo
in Magic ETL
image.png


Answers

  • GrantSmith
    GrantSmith Coach

    It’d be easier to pivot your data in an ETL and then use a formula tile or beast mode to calculate the difference between the two column values.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • lhongo
    lhongo

    @GrantSmith , I tried doing that but it was just not as straightforward as I expected,what should I have in

    Step 3 : Name a new column to create

    Step 4: What label identifies the rows that belong to this column

    Step 5: Select what values will populate this new column

Categories