Can I subtract two fields if the first field has a beast mode calculation?

kim_barragan0126
kim_barragan0126 Member
in Beast Mode

I want to subtract Amount from Test1 by using a beast mode. For example; week ending date 1/5/2025 I want to have a column for the difference of $514,953 - $154,400. In my test1 column I am using the SUM(Distinct) best mode. Will this cause me not to be able to subtract? I am not able to get a column that shows a difference between my two existing columns. Any ideas how I can complete?

image.png

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You just need to subtract your other aggregation in your beast mode:

    SUM(DISTINCT `Temp GP`) - SUM(`Amount`)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Yes, as @GrantSmith said you can subtract your other aggregation in your beast mode. You can also use nested beast modes by referencing the other beast mode in the second beast mode. Nested beast modes look like this:

    Screen Shot 2025-01-28 at 8.40.46 AM.png

    You'll notice the different colors. The greenish colored text is a separate beast mode calculation that is being referenced in this beast mode. The blue text is a standard measure. If you just start typing the name of the beast mode you want to use it will appear and have a "=" at the end of it:

    Screen Shot 2025-01-28 at 8.43.40 AM.png

    If I solved your problem, please select "yes" above

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You just need to subtract your other aggregation in your beast mode:

    SUM(DISTINCT `Temp GP`) - SUM(`Amount`)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Yes, as @GrantSmith said you can subtract your other aggregation in your beast mode. You can also use nested beast modes by referencing the other beast mode in the second beast mode. Nested beast modes look like this:

    Screen Shot 2025-01-28 at 8.40.46 AM.png

    You'll notice the different colors. The greenish colored text is a separate beast mode calculation that is being referenced in this beast mode. The blue text is a standard measure. If you just start typing the name of the beast mode you want to use it will appear and have a "=" at the end of it:

    Screen Shot 2025-01-28 at 8.43.40 AM.png

    If I solved your problem, please select "yes" above

  • kim_barragan0126
    kim_barragan0126 Member

    Thank you, both!

Categories