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

kim_barragan0126

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?

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:

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:

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:

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:

kim_barragan0126

Thank you, both!