How can I utilize double case statements in a beastmode

Anna_Otake
Anna_Otake Contributor
in Beast Mode

I want to create a beastmode where it calculates something like the below:

when segment = A then calculate the amount moved from A to B
when segment = B then calculate the amount moved from B to A (image below)

How can I calculate this using the beastmode functions?

Screenshot 2025-02-24 164059.png
Tagged:

Answers

  • Manasi_Panov
    Manasi_Panov Contributor

    Hello @Anna_Otake,

    I believe this is not possible with Beast Mode. ETL should be used to calculate this and create the new columns.

    If you found this post helpful, please use 💡/💖/👍/😊 below! If it solved your problem, don't forget to accept the answer.

Categories