-
Unique Count based on Revenue Amount
Hi All, I am working on a beast mode to count the number of contacts that have generated greater than $100k in revenue. I've tried the beast mode below, but it's only pulling null values. I kind of expected this to not work, but had to give it a try. (CASE when `Revenue Amount (Global)` > 100000 then COUNT(DISTINCT…
-
Beastmode YoY Variance Calc
Hi All, I am working on a beastmode that I thought would be relatively straight forward, but is giving me some issues. I am trying to do a YoY variance calc starting in 2022. The problem I am running into is that the 2021 numbers are not being subtracted out of the 2022 numbers. When I look at the previous year info, it's…
-
Beast Mode - Revenue from a negative to a positive
Hi, Novice beast mode user here and currently our data flow is showing revenue as a negative number and expenses as positive numbers, however I would like revenue to also show as positive. I tried the below beast mode calculation below, but it didn't work. Any advice on what beast mode calc, or other way, to turn revenue…