Beast Mode SUM Aggregation Workaround
I'm trying to structure a basic formula in Beastmode to calculate the total sum of a sales figure within a time range and then apply a multiplcation ONLY if it's positive. Dataset example (daily sales forecast): 1/1/2016 - $10 1/2/2016 - $-30 1/3/2016 - $40 Beast mode example: WHEN SUM(Sales forecast) > 0 then SUM(Sales…