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

kim_barragan0126 · 2025-01-28T08:08:31+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Accepted answers

GrantSmith

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

SUM(DISTINCT `Temp GP`) - SUM(`Amount`)

ColemenWilson

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

All comments

GrantSmith

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

SUM(DISTINCT `Temp GP`) - SUM(`Amount`)

ColemenWilson

kim_barragan0126

Thank you, both!